Tags: access, database, form, forms, game, microsoft, mysql, oracle, pause, press, rugby, sql, time, tostart

Time/Counter in Forms

On Database » Microsoft Access

2,650 words with 2 Comments; publish: Fri, 06 Jun 2008 13:51:00 GMT; (250140.63, « »)

Im wondering is it possible to have a time in a form.. that I can press to

start... and then press to pause etc...

Its for a game of rugby...

Id like it to start at 00:00 and then when i press a button it would start

counting up...

When it gets to Half Time (40mins) it would stop counting...

And then when the 2nd Half starts it would continue counting up to 80 Mins

.....

The counter needs to stay in mins... and not have say 1:13.52 for the 73rd

min

Im using Access 2000

Any ideas?

All Comments

Leave a comment...

  • 2 Comments
    • Every Form has a Timer Event. Just set the intrerval property to, say, 1

      minute. But leave it Disabled. Then, put Start and Stop buttons on the Form.

      In the Start button's Click Event, set the timer to Enabled. In the OnTimer

      Event, you would store the count of minutes in a Global or Static variable

      and increment it each time through. At 40 minutes, disable it again. Look up

      the OnTimer Event in Access Help for more ideas/samples.

      "The Boondock Saint" <robport.ms-access.todaysummary.com.(no-spam)inspire.net.nz> wrote in message

      news:43b32714$1.ms-access.todaysummary.com.clear.net.nz...

      > Im wondering is it possible to have a time in a form.. that I can press to

      > start... and then press to pause etc...

      > Its for a game of rugby...

      > Id like it to start at 00:00 and then when i press a button it would start

      > counting up...

      > When it gets to Half Time (40mins) it would stop counting...

      > And then when the 2nd Half starts it would continue counting up to 80 Mins

      > ....

      > The counter needs to stay in mins... and not have say 1:13.52 for the

      73rd

      > min

      > Im using Access 2000

      > Any ideas?

      >

      #1; Fri, 06 Jun 2008 13:52:00 GMT
    • Is that in office 2003? or would it also work in 2000?

      "Ron Hinds" <__ron__dontspamme.ms-access.todaysummary.com.wedontlikespam_garageiq.com> wrote in message

      news:uGbEmOBDGHA.2320.ms-access.todaysummary.com.TK2MSFTNGP11.phx.gbl...

      > Every Form has a Timer Event. Just set the intrerval property to, say, 1

      > minute. But leave it Disabled. Then, put Start and Stop buttons on the

      > Form.

      > In the Start button's Click Event, set the timer to Enabled. In the

      > OnTimer

      > Event, you would store the count of minutes in a Global or Static variable

      > and increment it each time through. At 40 minutes, disable it again. Look

      > up

      > the OnTimer Event in Access Help for more ideas/samples.

      > "The Boondock Saint" <robport.ms-access.todaysummary.com.(no-spam)inspire.net.nz> wrote in message

      > news:43b32714$1.ms-access.todaysummary.com.clear.net.nz...

      > 73rd

      >

      #2; Fri, 06 Jun 2008 13:53:00 GMT