SQL Update Date / Time info

[Oscar_W]

Fellas,

This is driving me nuts & despite searching I can't get it. I have very similar code in other forms which updates numbers and text variables to the underlying table but I can't get this one which updates the time (short time) to work. I am pretty sure that it is a formatting issue but can't see what

'Updates the Ops Log with new Start & Stop times
strSQL = "UPDATE Ops_Log_Table SET " & _
"StartTime = # & Me.StartTime & # ," & _
"StopTime = # & Me.StopTime & # " & _
"WHERE Request_DTG = '" & Me.Request_DTG & "'" & _
"AND Unit = '" & Me.Unit & "'"

DoCmd.RunSQL strSQL

Thanks,

Oscar

 

[Oscar_W]

This works now

"StartTime = '" & Me.StartTime & "' ," & _
"StopTime = '" & Me.StopTime & "'" & _

Thanks to Workmad3 post here http://www.access-programmers.co.uk/forums/showthread.php?t=110806

Oscar