daily query...

[fckPolice]

im trying to create an event where both an append and delete query will be automatically run as the date changes (they will run everyday at 12:00 a.m.)...any suggestions?

 

[pbaldy]

You could use the timer event of a form, but the mdb would have to be left running all night. You could also have problems if multiple users used the app, as the code could run more than once. I'd create a utility mdb that just ran your 2 queries when it opened, then closed itself. Then I'd run that mdb with Windows Scheduled Tasks every day at the desired time.