Concatenation w/Text & variable - Variable data contains Quotes
Posted on 2013-05-10
Here is the results>
UPDATE tblAPList SET Active = No, Failed = Yes, ErrMsg = 3011 ' The Microsoft Office Access database engine could not find the object 'R_MeasNoAddDlet'. Make sure the object exists and that you spell its name and the path name correctly.'
WHERE tblAPList.ApNo= '503'
strSQL4 = "UPDATE tblAPList SET Active = No, Failed = Yes, ErrMsg = " & _
Err.Number & "'" & Err.Description & "'" & _
" WHERE tblAPList.ApNo= '" & gApNo & "'"
What is the correct syntax?