Automatic Reporting----Need Advice please

[Darby]

Hello & thank you in advance for any advice.

I have several reports that the I would like to print automatically
on a certain day/time.
i.e. ReportOne - print every Friday at 3PM
ReportTwo - Print every Monday at 10AM

However, because the business is Seasonal, I only need this
setup for 2 or 3 months of the year.
How would I go about setting up a form so that a user
could turn automatic printing on & off for specific reports
and maybe even choose the date and time for printing.
I'm not even sure this can be done.
Can someone please advise me.

Thanks
Darby

 

[Jeff Boyce]

Darby

One approach might be to (generic concept to follow):

1. build a form with a Timer event that triggers the report, IF
2. a "config" table has a Yes/No field set to Yes (e.g., RunReport), AND
3. the config table has a LastReport1Date not equal to Date() (and R2 <>
Date())

Good luck

Jeff Boyce
<Access MVP>