var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Insert Into problem - quotes in field I am inserting...
Help, I am trying to insert from a text file into my db and the program breaks when the field I am inserting contains a ' ie [O'brian] or [Harvey's].
Here is the initial code. I tried to use chr(34) to no avail (perhaps I do not know how to build it in). Any and all help is much appreciated.
db.Execute "INSERT INTO tblAdhocsMain VALUES ('" & strFullPath & "', '" & dteDate & "', '" & strName & "', '" & strAdd & "', '" & strAdd2 & "', '" & strCity & "', '" & strState & "', '" & strZip & "', '" & strOther & "', '" & strOther2 & "', '" & strAcct & "')" 'insert into table
Can I ask you a simple question in return? Why are you using single quotes in addition to double quotes to create your execution string? (i.e "INSERT INTO tblAdhocsMain VALUES ('" & strFullPath ...
Are you using ODBC to execute something in another (non-Access) database?