System Time

[racdata]

Hi all

I have a text box to display the time on a switchboard

I get the time but I do not know how to display the system time because the time stand still and do not move by itself - the control source is =Time()

I want to see the seconds move

---12:22:45--- this is how the time is displayed

 

[GumbyD]

If your are on Access 2000 or later, in the form properties find the On Timer event and select [Event Procedure]. In the Timer Interval property type 1. In the event procedure code for the On timer event put the following:

Private Sub Form_Timer()
Text0.Requery
End Sub

You will need to change Text0 to the name of your time field.

The form will flash a bit but it should work.

GumbyD

 

[Pat Hartman]

Just an opinion. I don't think that it is a good idea to add the overhead of a timer event to display the time when the user can simply show the time in the system tray.

 

[doran_doran]

I agree

I agree with Pat.

 

[GumbyD]

I agree too - I was just giving him a possible solution.

GumbyD