Running code once per day

[Rick]

How do I get a code to run once per day at a specific time?

any help would be appreciated

Thanks,
Rick

 

[Glen Appleton]

Hi Rick,

First, create a macro with the RunCode action to run the function you need.
Next, create a shortcut to the macro (right-click -> Create Shortcut) which
will create a .MAM file.
Finally, create an event in Windows Scheduled Tasks and point to the .MAM
file.

It's that easy. :~)-

Hope this helps,
- Glen

 

[Joel Wiseheart]

In addition, if you perform any actions that perform
updates that provoke prompts, such as a make-table query,
you can suppress them by using SetWarnings to off, then
RunCode, then SetWarnings to On.

HTH
Joel

 

[Glen Appleton]

Good Point! And I should also point out that in Access 2003, you will need
to turn off the new security features to allow macros to run without
prompting.

- Glen

 

[Tim Ferguson]

Good Point! And I should also point out that in Access 2003, you will
need to turn off the new security features to allow macros to run
without prompting.

Another alternative is not to use Access at all, but to put the updates
into a VBS script, and run that with the Task Scheduler..

Tim F