Keep Time Current

[dargo72]

I currently have a Time() field on my form. Is there an easy way to add a line item to the current event so that it refreshes the time to stay current?

Thank you,

[orange]

See if this helps
http://office.microsoft.com/en-ca/ac...005187326.aspx

[Missinglinq]

To begin with, Time is a Reserved Word in Access and should never be used as the name of a Field/Control, so you need to change that.

Here's a thing I use. You'll need a Textbox called txtOmega (yeah, I'm a watch fanatic) and you'll maybe want to add some cosmetics to it, like a frame around it.

Go to your Form’s property box. Under the Event Tab find Timer Interval and enter 1000.

Private Sub Form_Open(Cancel As Integer)
'Displays while waiting for timer to crank up    
     Me.txtOmega = Time 
End Sub

Private Sub Form_Timer()
    Me.txtOmega = Time 'Display time
End Sub

Remember to change txtOmega to the actual name of your Textbox.

Linq ;0)>

[dargo72]

To begin with, Time is a Reserved Word in Access and should never be used as the name of a Field/Control, so you need to change that.

Here's a thing I use. You'll need a Textbox called txtOmega (yeah, I'm a watch fanatic) and you'll maybe want to add some cosmetics to it, like a frame around it.

Go to your Form’s property box. Under the Event Tab find Timer Interval and enter 1000.

Private Sub Form_Open(Cancel As Integer)
'Displays while waiting for timer to crank up    
     Me.txtOmega = Time 
End Sub

Private Sub Form_Timer()
    Me.txtOmega = Time 'Display time
End Sub

Remember to change txtOmega to the actual name of your Textbox.

Linq ;0)>

Thanks for the info. Actually, the field is NOT called Time, sorry for the confusion.

However, on the "event" tab, I do not see On Timer......... which is odd. I'm running 2007. Is it located somewhere else?

Thank you,

[dargo72]

Thanks for the info. Actually, the field is NOT called Time, sorry for the confusion.

However, on the "event" tab, I do not see On Timer......... which is odd. I'm running 2007. Is it located somewhere else?

Thank you,

Never mind.... found it....