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.
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.