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
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
Do you want just the Time or the Date and Time?
You could use:
Or for full date/time:Code:Private Sub Time1_Click() Me.txtTime.Value = Time 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).Code:Private Sub Time1_Click() Me.txtTime.Value = Now() End Sub
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.
Thanks so much. It works great.
Everette
My pleasure. Have a good weekend.