Mike- You need only one timer. Set the Timer Interval to the shortest value you need. Define a module-level or Static variable where you can count the number of times the timer has gone off. In the On Timer event, add 1 to the counter and then determine which of several processes you need to run.
For example, let's say you need to run something every hour, every three hours, and once a day. Set the Timer Interval to 3600000 - once per hour. Every time the interval fires, run your hourly task. If Counter Mod 3 = 0, run the every three hour task. If Counter Mod 24 = 0, run your daily task. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, January 30, 2006 11:52 AM To: [email protected] Subject: [ms_access] Using multiple "On-Timer" events at variable intervals Hi All, Is it possible to "nest" within a form (using subforms maybe?)multiple "On-Timer" events all occuring at their own specified intervals? I want to be able to use the "On-Timer" event to run various queries throughout the day, but some of them I will only need to run 1x per day, others multiple times per day. The idea is to have a hidden form load on startup with all of the timer events I need to run. As always - Thanks in advance for any help/suggestions :) ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
