I'm trying to use TimeOfDay in my code to enter the system time into a table (field "Time") each time the user enters a record.
My code (simplified):
Dim currentTime As Date
currentTime = TimeOfDay
sql="Insert into tblTime (Time) Values (" & currentTime & ")"
The actual dbconnection and sql statement worked until I added the "Time" field and " & currentTime &".
Is my reference to the varible correct?
Thanks in advance.