Countdown Timer on Form

[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

 

[Alex Dybenko]

Hi,
you can use form's timer event to get required number of seconds (if you set
timer interval to 1000 - it will hit every 1 second), then you can use
form's filter event to display required record

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[adam6b]

Thanks, Alex. I have been unable to access the timer event... Where can I
find this?

 

[Alex Dybenko]

open any form in design mode, open properties window, scroll down until you
find On Timer event

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[adam6b]

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

 

[Douglas J. Steele]

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.