startup question about access97 macro

[dk]

There is some documentation which seems to say that
if a macro is named autoexec it will run on startup in access97

i'm looking at a scheduler which lists the name of a macro in an
access project with a different name. It is called "agent"
I don't see any reference to the "agent" macro in the
startup screen- so question - how does this macro get to
be called first or called at all

tia
d

 

[Steve Schapel]

Dk,

I am not 100% clear what you are asking, but here are a few ideas that
may be relevant...
If an AutoExec macro includes a RunMacro action which calls another
macro, then this other macro will run when the database starts.
A scheduler can be set up to run a macro within an Access database by
using a /x switch at the end of the command line, for example the
command line might look like this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\MyDB.mdb" /x agent
A database can have its Startup options set under the Tools menu, to
open a particular form when the database opens, and then this form could
have code or macro on its On Load or On Open event to run another macro.