Timer event question

[Dennis Snelgrove]

Are there any conditions under which the Timer event stops? This is what's
happening to me.

I'm building a database of continuously updating and appending information
all of which is time/date dependent. I have 3 different customers who are
needing portions of the information, but each has a need for it in different
ranges of time and on different days. I want to have the computer wait until
approx. 2:00am each day, then spit out the appropriate reports. I've got a
hidden form that is holding a number of variables, and I'm using that form's
Timer to keep checking the time until 2:00am rolls around, then run a
routine to check the date and print any reports whose time has come. During
testing, it's working haphazardly at best. It triggers properly at times,
and other times it doesn't at all, and I can't seem to find any pattern to
base my debugging on.

Any comments or insights are greatly appreciated.

Thanks...

 

[TomU]

Is it possible that your code resets the TimerInterval property of the form
to zero? That stops the OnTimer event from firing.

Tom

 

[Dennis Snelgrove]

Nope. I have no code that affects the timer itself. When we change some VBA
behind an open form, does the form need to be closed and reopened for that
coding to take effect?

 

[East Coast Diva]

I don't know about the timer problem, but perhaps a solution would be to use
the task scheduler...???