Advertisement

05.22.2008 at 08:52PM PDT, ID: 23426567
[x]
Attachment Details

Auto generate report by using VBA in Access

Asked by angie_angie in Access Coding/Macros, Visual Basic Programming, Access Reports

Tags: VBA

I want to generate a report from the database in Access by writing some VBA code.
I will have a Form containing a text box where I can enter the ID, and by clicking "Enter" the system will generate the report for that particular ID.
I'm a beginner of Access VBA, hope someone could help me. Thanks!
I attached a sample database and a report template. Start Free Trial
Attachments:
 
Sample-db.mdb (264 KB) (File Type Details) 
Database containing 3 Tables
 
 
Sample-Report.doc (19 KB) (File Type Details) 
Report template
 
[+][-]05.22.2008 at 10:06PM PDT, ID: 21629501

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 10:07PM PDT, ID: 21629503

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 10:08PM PDT, ID: 21629509

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 10:52PM PDT, ID: 21629632

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 11:22PM PDT, ID: 21629758

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.23.2008 at 06:21AM PDT, ID: 21631826

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.23.2008 at 07:44AM PDT, ID: 21632554

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.23.2008 at 10:07AM PDT, ID: 21633904

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Visual Basic Programming, Access Reports
Tags: VBA
Sign Up Now!
Solution Provided By: boag2000
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.24.2008 at 01:56AM PDT, ID: 21638354

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628