Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Populating Report wtih values from a listbox (Access 2000)

    I am trying to populate a report with the names and addresses from a list box. I want the report to fit 3 names and address wide so it can fit a avery label template for printout. I am not sure how to get the report to populate each name in a listbox in the format I need. My Other option is to populate a word file, but I am not sure how to populate a word file with the information from the listbox. I know you can use bookmarks to get data in, but the only thing is there can be hundreds in a lists, and no two lists are the same length, so it would not be effective

    Example of what I need:

    Name1 Name2 Name3
    Address1 Address2 Address3

    Name4 Name5 Name6
    Address4 Address5 Address6

    Any help or guidence would be great

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Populating Report wtih values from a listbox (Access 2000)

    What do you mean, "populate from a listbox"? Normally a report will be populated from a query. How are you using the listbox?
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Populating Report wtih values from a listbox (Access 2000)

    Actaully, using a query would work as well. [img]/forums/images/smilies/smile.gif[/img] But the problem that still remains is how can I populate a report with the way mentioned above? Like have three address per row?

    Thanks

  4. #4
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Populating Report wtih values from a listbox (Access 2000)

    Actually I got it. There is a label wizard <img src=/S/clever.gif border=0 alt=clever width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •