Several reports, same question

[Pedro]

Hello everyone
I have like 30 reports to print every month. I will build a macro for it.
Quite simple i guess. Most of those reports have a query. Most of them, query
and reports have a filter and a criteria, but the real question is : I'd like
to "ask" from wich date to wich date to them all and of course that input
data appears on each report. I think i have to add a filter on my report but
i would like to print all 30 reports just saying one the date in and the date
out.
Hope i was clear and thanks in advance for all you can do for me.
Pedro

 

[Jerry Whittle]

Put something like the following in the criteria for the date field of the
queries:

Between [Forms]![frmRunReports]![txtStartDate] and
[Forms]![frmRunReports]![txtEndDate] +.9999

(Trust me on the + .9999)

Now create a form not linked to any table (AKA unbound form) named
frmRunReports. On this form put text boxes named txtStartDate and txtEndDate.
Also put a button on the form that will run the Reports macro.

Your users open the form, type in the dates, press the button to run the
macro, and it's off to the races.