Auto start the macro

[fatchoy]

Hi

I have create a new macro in the access database. Is there a
way to auto activate this macro wnenever I open the access database. It will be even better if there a way to schedule the macro to start at a specific time.

Thank in advance.

 

[SgtJarrow]

To make the Macro run when you open the database, use an AutoExec Macro (spelled exactly like that), and have this macro run the macro you want. Anything found in the AutoExec macro is run at startup. As for having it run as specific times, please see thread700-252426. This has my suggestions for this process. Please be sure and read the whole thread as another user pointed out one potential problem depending on what your macro does. Good Luck! %-) There is no I in team.

Robert L. Johnson III, A+, Network+
robert.l.johnson.iii@citi.com

 

[Junior1544]

if you want to make a macro run just say once a day, you can use a command line switch to just run that one macro... what is it you are tring to get done?? scheduling a compact on the database??

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.