Run macro daily

[shuchung]

Hi,

I have a macro which is required to run daily. Is there
any method to do so? I am not sure whether there are any
scheduling method in Access XP

 

[Pat Garard]

Since you MUST run Access, in order to run the macro,
I suggest you schedule Access itself, together with the
/x Switch.
Write a NEW Macro (say 'mcrSchedule') with two lines:
RunMacro mcrYourDailyMacro
Quit

Acess YourDatabaseNameAndPath //x mcrSchedule
--
Hope This Helps,

Pat Garard.
apgarardATbigpondDOTnetDOTau
_______________________________________________

"One look is worth a thousand rumours."
Wen Hou, Warring States Period.
"Look twice!"
Pat Garard, 2003.