ADO
I have a form in access where users submit there entries. There is one text(memo)field on the form. Whenever users use any types of apostrophes they receive an error. Is there a work around for this? see example below.
dim strtxtComments as string
dim db as databse
set db=currentdb
strtxtComments ="This is a test's"
strsql1 = "INSERT INTO tbl_Main_Quality (Comments)" & _
"select" & "'" & strtxtComments & "'"
db.Execute (strsql1)
|
