469,125 Members | 1,655 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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 1134

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 zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.