how do you schedule a macro to run daily?

[sraja]

hi

how do you schedule a macro to run daily?
I want it to update automatically daily or weekly if
possible

Thanks

 

[Steve Schapel]

Sraja,

You can use Microsoft Task Manager, or some other third-party scheduling
utility, to run the macro at your required times. Use a command line
syntax such as...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x NameOfMacro