Run code at specific times?

[clive2002]

I have two modules that i wish to run at specific times.

I want one to run at midnight everynight and the other to run at midnight on the first day of the month.

how do i do this and will i need to have the database open all the time or can i somehow set it to launch run the code and close again?

 

[JonH]

Here are at two ways of doing this. You can use the Timer event in Access to check the system time and run the code at midnight each night, after running the code you can close the database with DoCmd.Close but you'd need to open it up the next day to run that night. Likewise use a Timer to check for the first day of the month. You can only use one timer on each form so these would need to be different forms. The second way is to set scheduled tasks in Windows>Start>Program Files>Accessories>System Tools>Scheduled Tasks

JonH.