472,102 Members | 1,088 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,102 software developers and data experts.

Report Creation using VBA in ACCESS

1 Bit
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,
Jan 8 '21 #1
3 2599
409 Expert Mod 256MB
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
Jan 8 '21 #2
8,830 Expert 8TB
If you are a Beginner to Access, and you are looking to programmatically generate various Reports based on Multiple Criteria, then that may be a steep road ahead for you. Just my opinion.
Jan 8 '21 #3
32,496 Expert Mod 16PB
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.
Jan 8 '21 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Serious_Practitioner | last post: by
1 post views Thread by cdolphin88 | last post: by
1 post views Thread by newphpcoder | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.