Countdown Timer For Each New Record, Access 2010

[justair07]

Hello,

Maybe you've seen this at Pizza Hut.

I found several threads on how to create a countdown timer on a form but nothing to do exactly what I'm look for.



I have a form(frmMonitor) that I made to display all new records added. This form will be displayed on a monitor 24/7. It requeries every 5 seconds so all new orders are displayed right away.

Here's what I want: For each new record that is added, I would like for a countdown timer to begin (72 hourse, hh:mm:ss). I have two time fields on the main form. The first time field is populated with a cmdButton (Submit) using the now() function. As soon as they hit "Submit" the time field populates and the record is sent to the frmMonitor. This is were I would like the timer to begin. Once the order is seen it will be closed out by another person who will open the record in the main form and click another cmdButton (Complete), once this button is pressed I want the timer to stop.

My main question is how to create the timer and get it to start?

If anyone would like to help me out with this I can post my database.

[pbaldy]

If the start time is a field in the data, you should be able to have

Now() - StartTime

either as a calculated textbox on the form or as a field in the form's source query. Requerying the form should advance that timer.

[amrut]

Deduct the displayed value in the form's timer event. To show every second, the form timer interval should be 1000. To display different timers for different records, you need to "manipulate" all the records to be displayed, may be through query or recordset or temporary table ?? Quite tricky!!

[justair07]

I was hoping for the timer to be continuously running. What if I have a "start time" then another field "deadline" which will have a default value of the "start time" + 3days (or 72 hours). My main issue is how to have a timer that will countdown between the difference of the two dates.

I found some great code at http://www.access-programmers.co.uk/...d.php?t=166993 post #5. If only I could modify it to work for me. I just don't know how.

[justair07]

If I post my project would someone be willing to take a look at it for me, maybe try some stuff out?

[amrut]

I have a db I developed for fun. Have a look at it to get some idea for timer code. It was an attempt to show traffic signals with timer.Hope it is helpful to you. TrafficSignal.accdb