472,145 Members | 1,605 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

automating report printing....

I have developed a report in Access 2007 that runs on three queries, each promting an input from the user...this report is used for a meeting and it should be printed nine times...what I do now is open the report nine times, with each print i enter the same inputs for the first two queries and a different input for the third one...so this is becoming a hassle for me.. :(

Query1 takes the meeting date
Query2 takes the budget date
Query3 takes the member's ID ( the list of ID's is stored in a table in the database)

so in each print, the only difference is the member's ID...but now I enter the meeting date and the budget date again and again for each print.. :(

Is there a way I can enter the input for the first two queries once..like store it in a variable and only enter the input of the third query nine times?...

Also.. the input of the third query is in a table..so is there a way to have a loop that takes the input for the first two queries once and stores it in a variable, and reads the value for the third query from the table (with each cycle it reads the next record and gives it to the query, instead of promting the user to enter it)?...

I am really desperate to have this Loop...thanks

p.s I dont have any experience in VB programming
Aug 2 '09 #1
0 1206

Post your reply

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

Similar topics

1 post views Thread by steven | last post: by
4 posts views Thread by Supa Hoopsa | last post: by
2 posts views Thread by Dave | last post: by
reply views Thread by =?Utf-8?B?amRzdGVudG8=?= | last post: by
reply views Thread by Saiars | 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.