Run a batch of reports based on the same query

  • Thread starter Thread starter Penny Meholick
  • Start date Start date
P

Penny Meholick

I need to run (print) a batch of reports, all based on the same query. The
query asks the user for begin and end date.

Is there a way I can run all these reports from a macro WITHOUT prompting
the user to enter the begin and end date over and over and over? I'd like
to prompt the user once for the date range, then run all the reports based
on that input.

I'm sure it can be done, but I'm still at a loss after reading many pages of
help files......
 
Penny,

What I usually do is create a form where the user enters a
BeginDate and EndDate in unbound text boxes. I usually
have them check off which reports they want to view also.
Then in the queries that relate to the reports, instead of
parameter dates, I use: Between Forms!PrintForm!BeginDate
and Forms!PrintForm!EndDate.

I hope this helps.
AnnMarie
 
All you need to do is make the queries refer to a common
source form

Then you can run the macro to print each report.

NMcQ
 
Back
Top