I have a form that has code that is executed On Timer for a set Timer 
Interval. Sometimes when the user is working on the form (other code is 
then being executed) the timer stops and the only way to start it again is 
to close the form and re-open it. 

What can I do about this? Is this a MS bug or my bad programming? The code 
must run at least once every minute because it stamps the current time 
into a table and the whole database is based on that timestamp. Is there a 
better way to execute code on time intervals? Would another hidden form 
execute the On Timer code solve the problem?

Thanks beforehand

Bjorn Ottosson

what is the code that stops the timer code from running?

later,
bware

-----Original Message-----
From: bjorn@e... [mailto:bjorn@e...]
Sent: Wednesday, November 27, 2002 11:02 PM
To: Access
Subject: [access] Event TimerInterval stops


I have a form that has code that is executed On Timer for a set Timer 
Interval. Sometimes when the user is working on the form (other code is 
then being executed) the timer stops and the only way to start it again is 
to close the form and re-open it. 

What can I do about this? Is this a MS bug or my bad programming? The code 
must run at least once every minute because it stamps the current time 
into a table and the whole database is based on that timestamp. Is there a 
better way to execute code on time intervals? Would another hidden form 
execute the On Timer code solve the problem?

Thanks beforehand

Bjorn Ottosson