Clock

[Broads]

How in microsoft access can i program a clock which
updates automatically without the user having re-open the
form to get a new time, at current i can only get a
static clock which will only change every time you
open/refresh the form.

Thanx to anyone who can help!

 

[Wayne Morgan]

With the form open in design view go to the Event tab of the form's
properties sheet. Set the Timer Interval to the number of milliseconds you
want to update the clock (1000=1 second) and in the OnTimer event run the
code to update the clock.

 

[OzPete]

To add to Wayne's response, the code for OnTimer:

Me.Refresh

will update the clock, but it will also update everything else on the
form....

OzPete

With the form open in design view go to the Event tab of the form's
properties sheet. Set the Timer Interval to the number of milliseconds you
want to update the clock (1000=1 second) and in the OnTimer event run the
code to update the clock.