I have been staring at this for hours and can't see the syntax problem
pubFilePathName & strQuestion as both strings
Where is my syntax problem?
Thanks in advance
Code:
CurrentDb.Execute "INSERT INTO tblBackEndLocation(BackendLocation, ComputerDescription, dDate) VALUES " & _
"('" & pubFilePathName & "', '" & strQuestion & "', #" & Now() & "#)", dbFailOnError
pubFilePathName & strQuestion as both strings
Where is my syntax problem?
Thanks in advance