VB Timer for firing off macro at specified time intervals

[DropsIT]

I am trying to design a small database that records users logging into and out of an SQL based application. I have located the SQL table and the users and have already written the macro to record the relevant information to a history table. The problem is that I now need some sort of timer that can fire off the macro at specified time intervals.

Any ideas ?

 

[dhookom]

You can open a form with an event in its timer. The form doesn't have to be visible.

If the tables are SQL Server, I would think you could do this much more robustly on the server.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.