Quotes in string causing DAO error 1

[jrh1]

If I run the following code, the values test, test1,1 and 2 are inserted as a record into the entityPos table:

dbs.Execute " INSERT INTO entityPos(subModelNm,entityDisplayNm, horizontalPos,verticalPos) VALUES ('test', 'test1',1,2);"


If I change the values I am inserting into variables, the code fails:
dbs.Execute " INSERT INTO entityPos (subModelNm,entityDisplayNm, horizontalPos,verticalPos) VALUES (var1, var2,var3,var4);"

If I look at the value of the variable var1 or var2 Access is reading it with double quotes. How do I change it so that the variable is read with single quotes?

Thanks much in advance,
Jeff

 

[TonyJollans]

Hi jrh1,

Double quotes and single quotes are all the same to Access - but very different to VBA.

What is wrong is that you have your variable names inside a VBA string, so VBA is interpreting them as text and not as variables. What you need is ..

"INSERT INTO .... VALUES ('" & var1 & "', '" & var2 & "', " & var3 & ", " & var4 & ");"

Emjoy,
Tony