auto run a macro

[pm]

I have two macros that I run daily to pull external files. What I'd like to
do is automate the macros where they run when I open the database. Is this
possible?
thanks in advance for any help.

 

[Douglas J. Steele]

Create a macro named AutoExec that calls the two macros. The AutoExec macro
will run every time the database is opened.

 

[pm]

Thanks Doug, I'll try that.

Create a macro named AutoExec that calls the two macros. The AutoExec macro
will run every time the database is opened.

 

[a a r o n . k e m p f]

if you want to run scripts on a scheduled basis; you should move to
SQL Server and just use SQL Agent.

Seriously here.

-Aaron

 

[Tony Toews [MVP]]

I have two macros that I run daily to pull external files. What I'd like to
do is automate the macros where they run when I open the database. Is this
possible?

You can also create a item in a Windows task scheduler and run a
specific macro. See Startup command-line options for more details.
The command line would look something like

"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE" "Q:\1
access\Fleet Mgmt\Service.mdb" /x macro_name

TOny
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/