schedule task to run a report

[gls858]

I have a report that is set up in Access to mail itself when it's
run. Is it possible to schedule a task in the windows task scheduler
to run this report? I can get the scheduler to open the data base just
can't figure out how to make it run the report.
Is there a better method?

gls858

 

[Guest]

If you can get the scheduler to open the data base the create a macro named
Autoexec and have it to run the report and then quit.

 

[John Vinson]

I have a report that is set up in Access to mail itself when it's
run. Is it possible to schedule a task in the windows task scheduler
to run this report? I can get the scheduler to open the data base just
can't figure out how to make it run the report.
Is there a better method?

gls858

You can create a Macro which runs the report, and execute it from the
command line in the scheduler:

"C:\Program Files\Office\msaccess.exe" "F:\path\your.mdb" /x RunReport


John W. Vinson[MVP]

 

[gls858]

You can create a Macro which runs the report, and execute it from the
command line in the scheduler:

"C:\Program Files\Office\msaccess.exe" "F:\path\your.mdb" /x RunReport


John W. Vinson[MVP]

Thanks John and Karl. I appreciate the help. I'll give them both a try.


gls858

 

[gls858]

Thanks John and Karl. I appreciate the help. I'll give them both a try.


gls858

Managed to get both to work. Decided to use John's solution. I have several
people opening the data base and if I use the autoexec method it sends an
e-mail each time the db is opened. Now I just need to figure out how to
run it for the previous day and allow for week-ends but that's another
thread

gls858