AUTOEXEC MACRO

[Souris]

I know that Access can run AUTOEXEC Macro when it starts.
I can use Windows schedule to run the MS Access.
May I have one MS Access to control more than one schedule macro?
If I have many 4 auto reports, do I need 4 Access mdb file to have all
scheduled.
I would like to have one MS Access mdb file to control them.

Is it possible?
Any information is great appreciated,

 

[tina]

you can set pretty much whatever Actions you want to run, in an AutoExec
macro. if you have four reports to run, then put four OpenReport actions in
the AutoExec macro.

hth

 

[Souris]

I wanted to run them in different time.
Like one report is daily at 16:00, other is weekly on Friday 14:00.
Can I have different persiod report in one Autoexec macro?
Thanks agfain,

 

[tina]

use the Condition column in your macro sheet, and set the condition(s) for
each report. you'll have to put a little thought into scheduling when the
database is automatically opened, and how to coordinate that with the
Condition(s) that will be checked before each report is run. for instance,
you have one report that only runs on Friday. so part of the Condition for
that report might be

Weekday(Date()) = 6

in the above expression, 6 is equal to Friday. depending on when the
database is opened, and how long it stays open, you may have to check the
current system time when the database opens, and you may have to open a form
and utilize the Timer event to periodically check the system time.

hth

 

[Souris]

Thanks millions,

I wanted to run them in different time.
Like one report is daily at 16:00, other is weekly on Friday 14:00.
Can I have different persiod report in one Autoexec macro?
Thanks agfain,