Run a macro at a specific time

[jonnyboy101]

Hi all,

I would like to have a macro run at a set time each day. I hoped to use .ontime but apparently that doesn't exist in access.

The macro must run at 10:00am each day, the db will be open from 8:30am until 16:30pm so no problem from that point of view +/- a few mins when the staff arrive.

Hope someone can point me in the right direction.

Regards,

Jon

 

[pbaldy]

You can use the timer event of an open form, but personally I'd create a db that just ran this macro and quit, and run that db from Windows Scheduled Tasks.

 

[namliam]

Just seconding Paul's suggestion of a seperate db on a Scheduled task

 

[jonnyboy101]

You can use the timer event of an open form, but personally I'd create a db that just ran this macro and quit, and run that db from Windows Scheduled Tasks.

Thanks but the macro that it runs needs to interact with some data in the tables of the main database. So would it have to do a call or something?

 

[pbaldy]

You just link to those tables in this new db.