auto run a macro

P

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

Douglas J. Steele

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

pm

Thanks Doug, I'll try that.

Douglas J. Steele said:
Create a macro named AutoExec that calls the two macros. The AutoExec macro
will run every time the database is opened.
Click to expand...
 
A

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
 
T

Tony Toews [MVP]

pm said:
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?
Click to expand...

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/
 
Top