467,092 Members | 1,271 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,092 developers. It's quick & easy.

Report Creation using VBA in ACCESS

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,
1 Week Ago #1
  • viewed: 2024
3 Replies
Expert 64KB
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
1 Week Ago #2
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.
1 Week Ago #3
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.
1 Week Ago #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 ssimon@theeventwizard.com | last post: by
1 post views Thread by cdolphin88@yahoo.co.uk | last post: by
1 post views Thread by newphpcoder | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.