Report Creation using VBA in ACCESS

[azan]

Hi Team,

i am beginer to microsoft access. i am trying to create a report programatically in vba and i need your help in this. i have 3 tables a,b,c and i have written 2 queries q1,q2 which will be working based on listbox value selected by user. if user selected "All", q1 will be triggered and various reports should be created. please help me. thank you in advance.

Thank you,
azan

[isladogs]

I believe you are saying the report data should depend on the values selected in two listboxes on a form.
The way I recommend is to build a filter string concatenating ('joining') each of the selections.
Its easier to understand if you look at examples and I have several example apps you could look at to help you with this.
Please do a Google search for 'Multiple Group and Filter- Mendip Data Systems' which includes two examples.
Hope that helps

[ADezii]

If you are a Beginner to Access, and you are looking to programmaticall y generate various Reports based on Multiple Criteria, then that may be a steep road ahead for you. Just my opinion.

[NeoPa]

Hi Azan.

I'm afraid we're prohibited from giving solutions for class assignments here. This sounds very much like a class assignment. I can't imagine any other reason for requiring the Report to be designed via the medium of code.

It's also a project specification rather than a request for help with a specific aspect so as it stands we are not able to help you.