Its a syntax error but I'm struggling.
I have a table that I insert a start time ( Now() ) and the text "Full System Update" int the TEXTCONFIRM field.
What I want to do is update the EndTime of that record.
In the meantime I am opening an update query but wondered what is wrong with the code.
I want to utilise using SQL coding more and wondered if using RunSQL is recommended in VBA ?
Thanks for your thoughts and advice.
I have a table that I insert a start time ( Now() ) and the text "Full System Update" int the TEXTCONFIRM field.
What I want to do is update the EndTime of that record.
In the meantime I am opening an update query but wondered what is wrong with the code.
Code:
DoCmd.RunSQL ("UPDATE Update_Log SET Update_Log.EndTime = Now(WHERE (((Update_Log.TEXTCONFIRM)='Full System Update'));")
I want to utilise using SQL coding more and wondered if using RunSQL is recommended in VBA ?
Thanks for your thoughts and advice.