Closing Delimiter error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AkAlan - 28 Feb 2008 19:17 GMT

Hi All, I am getting an error when there is an apostrophe in the Comments
text box. I tried using double double quotes in place of the single quotes
but get a different error then. Here is the code I use, thanks for any help.

strSql = "INSERT INTO tblPmiHistory (PmiId,EquipId,Employee,StartDate,
FinishDate,DateSchedOriginal, " _
& " DateSchedCurrent,Comments,TaskId,PerfWc )" _
& " VALUES ('" & Me.PmiId & "','" & Me.EquipId & "','" & Me.Employee
& "','" & Me.StartDate & "','" _
& Me.FinishDate & "','" & Me.DateSchedOriginal & "','" & Me.
DateSchedCurrent & "','" _
& Comments & "','" & Me.TaskId & "','" & Me.txtPerfWc & "'" & ")"

Reply to this Message

Sylvain Lafontaine - 28 Feb 2008 23:56 GMT

When building a sql string, if you are using the single quote as the string
delimiter, then you must use double single quotes inside it; when it's
double quotes, you must use double double quotes. The situation is also
more complicated because the situation can repeat itself with the VBA
strings when you are using the double quotes for you sql string delimiters.

In your case, try replacing « Comments » with « Replace (Comments, "'",
"''") ». It's a good idea to display the result of strSql after that to
verify that everything is OK.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

> Hi All, I am getting an error when there is an apostrophe in the Comments
> text box. I tried using double double quotes in place of the single quotes
[quoted text clipped - 10 lines]
> DateSchedCurrent & "','" _
> & Comments & "','" & Me.TaskId & "','" & Me.txtPerfWc & "'" & ")"

Reply to this Message