Automatic Reporting----Need Advice please

  • Thread starter Thread starter Darby
  • Start date Start date
D

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
 
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>
 
Back
Top