Countdown Timer on Form

  • Thread starter Thread starter adam6b
  • Start date Start date
A

adam6b

MS Access 2000:

I need to create a countdown timer on a form that references a field in a
table for the number of minutes. When the timer hits zero I would like for
it to bring up a box that says something like "Begin Next Level?" then change
the name of a Text Box to the next line from the previously referenced table
and begin the next countdown.

My table is layed out like this:
Level - Rec1 - Rec2 - Timer1 - Timer2
1 10 20 30 0
2 20 40 30 5

On my form, I would like to hit a button that begins the process in level 1:
displays the level, Rec1 & Rec2 on my form and counts down for the length of
minutes in Timer1. When it gets to zero I need it to beep, blink, etc. Then
display a mesage asking if I want to run the countdown in Timer2 or move to
the next level.

I am familiar with some basic VBA in Excel, but I'm struggling with Access

Thanks,
Adam
 
So how can I make a timer actually display in the text box? I have narrowed
down what I actually need to this...

- Start the timer with the number of minutes based on a specific field in a
query
- When it hits zero notify me with a beep and flash
- Prompt box asking to move to next level
- On Yes - add 1 to a text field on my form and then Back to top of macro
- On No - another Prompt box - "Do you want to end session?"
On Yes - stop timer
 
Have the TimerInterval set to some smaller value (say 1000, for 1 second)
and write a new value out to the text box each time the Timer event fires.
 
Back
Top