Schedule a MACRO

[LebronJames]

I have an Access 2000 database that contains a macro. Does anyone know of any schedulers that I can use to run the macro every hr and daily?

 

[scriverb]

There are a number of ways to do this but here are two:

1.

http://www.snapfiles.com/get/hal.html

follow this link and download a free software that basically is a MS ACCESS scheduler. You can setup a database with an autoexec macro to run your code then schedule it to run using this software.

2. In a database you can use the OnTimer event procedure to monitor the time and compare it to preset trigger times that will execute your code from within this procedure. A table of procedures and times to run could be created and the Ontimer event procedure could could loop through the records and trigger those that meet the requirements at this time.

Good luck with this. Post back if you have any further questions.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[PHV]

Take a look at the Timer event procedure and at the TimerInterval property.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[scriverb]

The link I provided to HAL somehow picked up the word "follow" which part of my text. Here is the correct link:

http://www.snapfiles.com/get/hal.html

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]