473,511 Members | 10,974 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Report Creation using VBA in ACCESS

1 New Member
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
Jan 8 '21 #1
3 2785
isladogs
457 Recognized Expert Moderator Contributor
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
ADezii
8,834 Recognized Expert Expert
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
NeoPa
32,557 Recognized Expert Moderator MVP
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

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

Similar topics

3
19578
by: Jay Best | last post by:
Hi there The story is as follows: I write up some pretty detailed reports on people, and what I am wanting to do is speed up the process as a proportion of the reports that I am writing are...
1
1998
by: Ted Sung | last post by:
Hi, We are moving to using mysql as our db and we have some reports already written in Access. Is there a way to create a stand alone EXE that will run the report from Access and then use a DSN...
6
1984
by: Serious_Practitioner | last post by:
Good day all, and thank you in advance for your help. No - MANY thanks in advance for your help - I know nothing about using databases on Web servers. I am about to discuss a project with a...
1
1397
by: ssimon | last post by:
I have created an Access DB for my company to tarck suppliers. The lookup forms we created give us data back in spreadsheet format and it is hard to follow. There must be a way of using Access...
1
1566
by: cdolphin88 | last post by:
Hello, I'm new in creating report in Ms-Access and I have some questions. I want to display a text Hong Kong Dollars when a field in my database is = "HKD" and display a text Patacas when this...
1
6321
by: Rutko | last post by:
Is it possible to dynamically create report and save it in rpt file? For example I want to add an text object in report on x,y position in page header. I need that dynamically, because I have a...
0
1599
by: Steve1974 | last post by:
Hi All I am currently using Access to output to excel. The creation of the worksheet goes ok, and then I have a piece of code (recorded from an Excel macro) to create pick lists for two columns...
5
13174
by: Linds | last post by:
I have a report within my access database that I would like to have a shortcut on my desktop that could bring up that report. In other words, now I have to double click on the database, then go...
1
2960
by: newphpcoder | last post by:
Good day! I upgrade my version of mysql from mysql 4.1.10 to mysql 5.0.15. Now I used phpmyadmin to access my database using XAMPP. Now, I need to create a report generation and I have no idea how I...
0
7144
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7427
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7512
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5671
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4741
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3227
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3214
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1577
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
449
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.