Several reports, same question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pedro - 10 May 2007 18:01 GMT

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

Reply to this Message

Jerry Whittle - 10 May 2007 19:37 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Hello everyone
> I have like 30 reports to print every month. I will build a macro for it.
[quoted text clipped - 6 lines]
> Hope i was clear and thanks in advance for all you can do for me.
> Pedro

Reply to this Message