Help for Newb: Running an Access Macro
Moderators: Dorian (MJT support), JRL
Help for Newb: Running an Access Macro
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
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."
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]
[email protected]
