May 26, 2004 #1 kammilla Instructor Jan 19, 2003 5 NO In a form in Access I want a field who always show me the correct time hh:mm:ss What shall I do in this field ??
In a form in Access I want a field who always show me the correct time hh:mm:ss What shall I do in this field ??
May 26, 2004 #2 PHV MIS Nov 8, 2002 53,708 FR Take a look at the TimerInterval and OnTimer properties of your form. Hope This Help, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 Upvote 0 Downvote
Take a look at the TimerInterval and OnTimer properties of your form. Hope This Help, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
May 26, 2004 1 #3 hymn Technical User Feb 27, 2003 1,036 GB Hi: Put this code in your form's ON LOAD event: Me!lblClock.Caption = Format(Now, "dddd, mmm d, yyyy, hh:mm:ss AMPM") Me.TimerInterval = 1000 Put this code in the TIMER INTERVAL event: Me!lblClock.Caption = Format(Now, "dddd, mmm d, yyyy, hh:mm:ss AMPM") Then, but a label on the form called "lblClock" (without the quotes) and you're done. Borrowed from someone Hope this helps Hymn Upvote 0 Downvote
Hi: Put this code in your form's ON LOAD event: Me!lblClock.Caption = Format(Now, "dddd, mmm d, yyyy, hh:mm:ss AMPM") Me.TimerInterval = 1000 Put this code in the TIMER INTERVAL event: Me!lblClock.Caption = Format(Now, "dddd, mmm d, yyyy, hh:mm:ss AMPM") Then, but a label on the form called "lblClock" (without the quotes) and you're done. Borrowed from someone Hope this helps Hymn