VBA rookie needs help

[everette]

I'm trying to do a auto time stamp using the code below. Does not work. Any help would be greatly appreciated.

Private Sub Time1_Click()
Dim Time1 As String
Time1 = Time

End Sub




Thanks in advance
Everette

[slave138]

Do you want just the Time or the Date and Time?

[everette]

Do you want just the Time or the Date and Time?

Just the time, but thinking time and date would be good.
Thanks
Everette

[slave138]

You could use:

Private Sub Time1_Click()
   Me.txtTime.Value = Time
End Sub

Or for full date/time:

Private Sub Time1_Click()
   Me.txtTime.Value = Now()
End Sub

This assumes you want the timestamp to be stored/displayed in a field (called "txtTime" on the same form as Time1 (which I assumed was a button).

If my assumptions were way off from what you are doing or hope to accomplish, please provide more details on your setup or upload a copy of the DB.

[everette]

Thanks so much. It works great.
Everette

[slave138]

My pleasure. Have a good weekend.