Run macro automatically?

[jtaplin]

I have a macro that I would like to automatically run at a set time every day. How can I do this?

 

[D-Fresh]

What you could do is name the macro "AutoExec". This will have it run when the database opens. Then you can open up the database at a certain time using Windows Task Scheduler. The syntax to open up the DB is C:\AccessPath\msaccess.exe c:\DBPath\DbName.mdb. At the end of the macro, add the Quit action, so Access will close automatically after the macro is completed. If you want to open the database in the future without running the AutoExec macro, you'll have to hold down the shift button while you open up access. Hope that helps.

Doug

 

[stevenjones35]

You can setup a form and set the on timer function to program the form to run a conditional macro where now()>"7:00am" (or whatever time).. It is pretty easy technically but may require some playing around with... You can buy already made programs that use exactly this methodology, my favorite is http://macros.subpacket.com , its open source and you can change the macro to suite for needs...