Help for Newb: Running an Access Macro

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
jplappo
Newbie
Posts: 2
Joined: Tue Jan 06, 2004 3:37 pm
Location: Tulsa, OK

Help for Newb: Running an Access Macro

Post by jplappo » Tue Jan 06, 2004 3:40 pm

What is the best way of using the Scheduler to run a Microsoft Access macro? We bought the program to run to email automatically some reports, but we need to get this functionality to work. Is it done from a command line? What would be the correct syntax? Thanks in advance

User avatar
support
Automation Wizard
Posts: 1450
Joined: Sat Oct 19, 2002 4:38 pm
Location: London
Contact:

Post by support » Tue Jan 06, 2004 5:44 pm

Hi,

Run>c:\bla bla bla\msaccess.exe mydatabase.mdb /x macroname

From the Access help file under 'Startup command-line options':

"/x macro Starts Microsoft Access and runs the specified macro. Another way to run a macro when you open a database is to use an AutoExec macro."
MJT Net Support
[email protected]

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts