Searching for a name with an apostrophe in it using DAO

[Slarti]

I'm using VB to connect to an Access database. I have table of customer records and need to search for a customer by name. I'm having trouble searching for names with an apostrophe in such as O'Leary, O'Donnell etc. The SQL I'm using is SELECT * FROM tblCustomer WHERE sName LIKE '*" & sRequiredName & "*'" where sRequiredName is the parameter and is a string variable. Where am I going wrong?
Thanks in anticipation.

 

[mmilan]

Doesn't access use double quotes as string delimiters?

Ps. Do you know where your towel is?

mmilan

 

[TomKane]

One of the ways to get around this is to "double" up on your single quotes what I mean by that is doing something like:

sRequiredName = Replace(sRequiredName, "'", "''&quot

SELECT * FROM tblCustomer WHERE sName LIKE '*" & sRequiredName & "*'"


Hope this helps...

 

[LostInCode]

Best is to use a command and parameter object (check the FAQs).

Or use:

...LIKE " & Chr$(34) & "*" & sRequiredName & "*" & Chr$(34)

 

[Slarti]

Thanks men. I'll try some of these.

Did you pinch my towel?

 

[671391]

MY COMPUTER DOES NOT BOOT UP, THEN IT SHUTS DOWN AFTER SOMETIMES

 

[mmilan]

???

 

[BiggerBrother]

671391 - first post - bit of an error. If you want to place a question, start your own thread, rahter than asking a separate issue question in someone else thread. Also, for anyone to be able to help you, they need more information than you have given here.

And finally, I don't think this is the forum where you want to ask that question. Try in the windows forum of tek-tips.

Good luck

BB