Dual Timer while still working

[spinkung]

Hi All,

Apologies if the title is unclear.

Here's what need to achieve....

Someone will create a new document (in a form) which will go off and query a database to get some header details. Once the form is created i need to create 2 timers.

Timer 1 : will be a 45min timer and a pop up needs to appear if the 45 mins is reached. Also need to reset the timer if someone enters a value in a specific text box.

Timer 2 : same as above but with a 2hr timer

The timers need to run concurrently and also the user must be free to type in fields on the form?

Is this even possible in Access?? where do i begin??

Thanks. Spin.

 

[pbaldy]

Re: Duel Timer while still working

A form can only have one timer running, but the event can test two variables. I'd have two form-level variables that represent your "target" times, and test them both in the timer event (every minute or so). You can reset either one or both from the after update event of the textbox.