Scoreboard Timer

[bgarey]

I want to make a scoreboard (countdown) timer on a form that my children can use for basketball games.
I do not know visual basic. I know there are VBA codes for this, and I can cut and paste. But I need step by step instructions on how to set this up.


Any help?

[ranman256]

In a form, put a label...lblTime. Set it to your start time.
In the form property is timer. Set it to 1000. This is 1 second.
in the events, ON TIMER
this event will now fire every second
so we set the label to change every time
lblTime.caption =dateadd("s",-1, lblTime.Caption )

you can also set the on key down event if the user presses space bar, it will pause the timer...
which would be timer interval =0

[bgarey]

Sorry it has taken so long to get back.
I really am a novice here.
I copied the code into the events procedure for the ontimer.
But I am just getting an error.
Not sure about any of this.

[bgarey]

Ok I have a timer that counts down now.
Thanks
But how do I format the label for just minutes and seconds
mm:ss
and how do I set the initial time, for example 07:00?

[bgarey]

I would also like a button that starts the timer, pauses it, and a reset.
A buzzer when it gets to Zero.

Any help?

[June7]

A label cannot be 'set' for data display formats. Can use Format() function.

lblTime.Caption = Format(DateAdd("s",-1, lblTime.Caption), "nn:ss")

However, because the Format function results in a string, not actually a date/time value, the calculation will likely error. So instead of label use a textbox. Textbox does have property for data formatting.

The only example of a stopwatch I could find is a VB6 project. VB and VBA code are very similar. If you have VB6, can open the project and view the code. It would probably be adaptable to VBA. I have done that before. http://www.freevbcode.com/ShowCode.asp?ID=8560

[bgarey]

Thanks so much! I now have a score board timer. I can start, pause, reset the clock. And I have learned a little VBA along with it. I can make it "beep" when zero. But I would like it sound off a buzzer sound. My if then statement works for stopping the timer and the "beep".
What is the code for playing a sound file?
And thanks for the help so far!

[June7]

Bing: Access sound file

http://allenbrowne.com/func-04.html

[bgarey]

Thanks to all!
This really works. I just have to add in scoring for home and away teams, but I got that part.