schedule a task to run a report

[trevorC via AccessMonster.com]

I need to use the Windows task scheduler to run a report, I can see how to do
this if the access file is closed. What if the file is currently open ?
regards
Trevor

 

[Crystal (strive4peace)]

Hi Trevor,

use a different database for the scheduler task ...

link to all your tables, put your report in there and
anything else it needs

create an AutoExec macro that opens the report (which will
automatically print unless you specify otherwise) and then
exits Access


Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
have an awesome day
*

 

[trevorC via AccessMonster.com]

Crystal (strive4peace) wrote:

Thanks for the reply Crystal.

Looks like the only way to do it other than hard code in the timer event...

 

[Crystal (strive4peace)]

you're welcome, Trevor

I try to stay away from timer events. No big deal to make a
another database for the scheduler -- what difference does
it make which file is opened? The report should be the same
regardless.


Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
have an awesome day
*