This is my sql string it works fine if i use a value instead of a variable. Does anyone know how I can fix this. Its slowly starting to drive me insane.
pstrSQL = "INSERT INTO tblstuff(stuff)VALUES('" & modname & "');"
Thanks,
Matt
Printable View
This is my sql string it works fine if i use a value instead of a variable. Does anyone know how I can fix this. Its slowly starting to drive me insane.
pstrSQL = "INSERT INTO tblstuff(stuff)VALUES('" & modname & "');"
Thanks,
Matt