Microsoft Access 2003 - Dynamic Time?

[Jonny M]

I can insert the time and date into a form using Insert > Date and Time on the menu, but is there a way to make it show the correct time, instead of just when the form loads? I was thinking something along the lines of updating it every second, but I'm not sure how to go about it.

Thanks

[Shad]

Can you not insert the time when you save the record rather than when you load the form?

[Falcon2004]

Hi

Am i right in assuming you want to add a real time clock to a form? If so hes how to do it.

If not, ignore the rest of my post

1. Open form in design view
2. Create a textbox where you want your "clock" to be.
3. Delete the label
4. Select the text box properties and and click the other tab and set the format to "long time"
5. With the properties still open click the "form selector", click the event tab and set the timer interval to 1000.
6. click the three dots next to the "On Timer" option and choose "code Builder"
7. Edit the code so it shows

Private Sub Form_Timer()
[Timer1]=now
End Sub
8. Close the Vb edititor and go to view, your clock SHOULD now work.

Falcon

Edit: This will take the time from the system clock, so this time has to be correct for thsi function to work.

[Jonny M]

Cheers Falcon, that was it