scheduled macro

[Tom B. Cruise]

How do you make a macro to run every night? Thanks.

 

[Duane Hookom]

Tom,
Congratulations on the Golden Globe!
The method I use is to schedule Access to start up at a particular time of
the day. You can add a macro name to the command line. I used Scheduler from
http://www.mvps.org/access/resources/downloads.htm.

 

[Tom B. Cruise]

Duane,

I can see how it assign a mdb to the command line. How do you
assign the macro to a command line? Can you please give me an example?
Thanks.

 

[Duane Hookom]

Check Help on "Startup command-line options"

 

[Steve Schapel]

Tom,

Apart from using a command line switch as Duane suggests, for which the
syntax is...
/x macroname
.... you could also use an AutoExec macro, which automatically runs every
time the databse is opened.