Is it possible to create a public function, available to any form that provides the TimerInterval function? How would you access the function from a form?
I'm looking for the same thing. In VB 6.0 you have access to ActiveX timer controls. I'm trying to find one that works with Access that doesn't cost alot of money.
If your pockets are deeper than mine, there is a company that offers some pretty nice ActiveX controls (including a timer) at www.FMSINC.com
I hope this helps. If anyone else knows about a free Timer control, please let me know as well.
Don't know if this helps but I use a little form to run all my timer events from. It opens with the db but is minimised, and made so it can't be seen.
Go to the form's properties, put a value in the Timer event (default 0) like 5000 for example, then bring up the 'OnTimer' event code window and there you go, you can call functions and public subs etc from the timer event...
