Auto Weekly and Month Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set up a report to automatically run every Monday morning for Monday
through Sunday of each week.

Also, How do I set up a report to automatically run on the last day of each
month?
 
There are a couple of ways to accomplish this. How you do it depends on the
nature of your application. One way would be to have a routine in your
startup form that would check the day of the week, have a way to know if the
current week's reports have been run, and run the reports.

If you require unattended production of the reports, you could create a
separate mdb that would launch your reports process and have that application
run from Windows Event Scheduler.
 
Create a new mdb file
Import all the objects required for your reports
establish links to the tables you need
Either create an Autoexec macro that will run the reports or indentify a
startup form that will run the reports

To set up the scheduler:
From your Windows task bar
Start->Control Panel->Scheduled Tasks->Add Scheduled Task
Follow the Wizard
 
Back
Top