I used =now() in a text box and that nicely displays date and time at
the moment of opening
How would I show updated data?
I thought of an event procedure, but which one would I use since there
really isn''t any data choosing or mouse event associated with the
date/time update
Jerry
解决方案Try the "On Timer" event.
wrote in message
news:ol********************************@4ax.com...I used =now() in a text box and that nicely displays date and time at
the moment of opening
How would I show updated data?
I thought of an event procedure, but which one would I use since there
really isn''t any data choosing or mouse event associated with the
date/time update
Jerry
wrote in message
news:ol********************************@4ax.com...I used =now() in a text box and that nicely displays date and time at
the moment of opening
How would I show updated data?
I thought of an event procedure, but which one would I use since there
really isn''t any data choosing or mouse event associated with the
date/time update
Jerry
You want to show a ''working clock'' on your form which just displays the
current time and is not bound to any data? You could use the form''s Timer
event and update every minute, second or whatever.
Or are you talking about showing the date and time a record was created or
amended?
je*********@pioneer.com wrote:I used =now() in a text box and that nicely displays date and time at
the moment of opening
How would I show updated data?
I thought of an event procedure, but which one would I use since there
really isn''t any data choosing or mouse event associated with the
date/time update
The forms in Microsoft Access have a Timer event.
For a form named frmMain with a label lblTime, you''d have code that
looks something like this:
Private Sub Form_Load()
With Me
.TimerInterval = 1
End With
End Sub
Private Sub Form_Timer()
with Me
.lblTime.Caption = Now()
End with
End Sub