What is escape key in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bookreader - 30 Jan 2006 19:42 GMT

What is the excape key to use in VB so that I can pass to Access an
insert statement with an apostrophe in the value?

Example
Dim strInsert As String
strInsert "Insert into names (Client) VALUES ('Art's Market');

That apostrophe in Art's Market causes problems.

Thanks.

Reply to this Message

Jay Taplin - 30 Jan 2006 20:04 GMT

Double apostrophes...

strInsert = "Insert into names (Client) VALUES ('Art''s Market');

I use this routine in all of my apps where I use an actual SQL command
to INSERT.

Public Function sWrap(Value As String) As String
sWrap = "'" & Replace(Value, "'", "''") & "'"
End Function

Reply to this Message

Bookreader - 30 Jan 2006 20:08 GMT

>Double apostrophes...
>
[quoted text clipped - 6 lines]
> sWrap = "'" & Replace(Value, "'", "''") & "'"
> End Function

Cool.

Thanks

Reply to this Message

VB Forum / Database Access / January 2006

What is escape key in access