473,390 Members | 1,686 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,390 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 2781
455 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,834 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,556 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

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

Similar topics

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...
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...
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...
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...
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...
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...
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...
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...
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...
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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...

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.