Running code once per day

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

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

any help would be appreciated

Thanks,
Rick
 
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
 
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
 
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
 
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.
Click to expand...

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
 
Back
Top