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.
> 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?
SharonInGa - 16 Nov 2005 15:26 GMT
Can you explain in more detail how to set up a separate mdb with a schedular?
> 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
[quoted text clipped - 10 lines]
> > Also, How do I set up a report to automatically run on the last day of each
> > month?
Klatuu - 16 Nov 2005 15:35 GMT
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
> Can you explain in more detail how to set up a separate mdb with a schedular?
>
[quoted text clipped - 12 lines]
> > > Also, How do I set up a report to automatically run on the last day of each
> > > month?