Access 2000 Listbox - Multiselect Reports

[Benny Wong]

Hello All,
I hope someone can help me on this one. I would like to generate a report from a listbox with the multiselect feature in which a user can select multiple items within the listbox and generate the report. I am currently using Microsoft Access 2000. I'm new to Access 2000, please outline what I need to do to make this happen.
So far I have the table built with the relationship set and normalized. The table name is for the one-side is tblclient. The table name for the many-side is tblcontacttype and tblPracticeGroup. I can currently run report via the macro way by calling the macro-sheet and reference the report for the individual field which pops-up a parameter. I would prefer not to use the parameter query method but rather use the listbox selecting the items listed to generate my report. An example would be like first name Bruce , Tom, Scott, Paul, All, etc..., I would like to select one, multliple, or All to generate the report. I'm going crazy trying to figure this out. So PLEASE! anyone having sympathy for me help me " HELP I need somebody!" Please outline what I need to do and if there is VBA code please tell me where to put it. Thanks for your time, effort, and sympathy in advance.

 

[Adrianna]

Benny,
It is always a good idea to Search the forums before posting a question or request. I know that sometimes it is hard to find something that works exactly like you want. That is when you ask for help!

Anyway, this old posting should help you out:

Old MultiSelect ListBox Posting

 

[Benny Wong]

Listbox Multiselect - Access 2000

Hello Adrianna,
Thank you very much for responding to my plea. I've downloaded the zip file "musiccollection.zip" and reviewed it.
I now understand the row source property that references the table via a query. However, when I ran the form and make the selection from the listbox and press the PrintPreview button nothing happens. I checked the event property of the PrintPreview button and nothing was there. I though the on click would be where you put the code? If there is to be code what would it be? Thanks for your response in advance.

 

[Adrianna]

Wrong Zip File

Benny,
I didn't mean for you to download the problem database. I wanted you to scroll down and download the musicsolution.zip file that I posted.
I was a little confused trying to figure out why my solution would not function on your computer...then I realized that you'd downloaded the wrong database.
I guess it's been just as long and frustrating a day for you as it has been for me

Please download the Music Solutions.zip at the end of the posting link that I provided above!

 

[Benny Wong]

Access 2000 - Listbox multi-select

Good Morning Adrianna,

THANK YOU! THANK YOU! Downloaded the file and trying to digest the process and understand the coding portion. I really appreciate your efforts in assisting me. I have followed up with my boss on it and he wanted to know two things:
1. Can the listbox contain a field called "ALL" so the user can select all the fields instead of highlighting each row of the listbox?
If so, what code do I need to modify?
2. Does this listbox multiselect sample principle applies to multiple listboxes? If so, what do I need to do?
Both my Boss and I are especially grateful for your efforts and assistance. I know I'm asking alot of questions but I'm getting so motivated!!! what book would you recommend for me to read up on Visual Basic for Application.
Thanks for your response in advance. I hope you are having a great day, you have made my day! Thanks!

 

[Rich]

Article ID: Q128881

 

[Adrianna]

Benny!

Are they thankful enough to provide me employment!!

I'm actually employed at the moment, but I had been thinking about switching coastlines!

Anyway, as for the all selection:

Simple Examples of various functions

The site above addresses one of your questions. As for the other question....you my apply this to multiple list/combo boxes, but mindful not to have one variable cancel out the other!

I hope that was enough of an answer. I'm a little busy today, but I will check back tomorrow.