Names with apostrophes 3

[Hargreavesk]

Hi,

I'm using the following code on a search form:

Dim db As Database
Dim rs As Recordset
Set db = CurrentDb

Set rs = db.OpenRecordset("SELECT * FROM [TBL ChequeDetails] " & "WHERE Name LIKE '*" & Me!Name & "*'&quot

When I search for a name such as O'Brien, I get an error because of the apostrophe. Can anyone suggest some changes to my code as I'm baffled.

Regards

Kate

 

[petersdaniel]

use double quotation marks to find values that contain single quotation marks and use single quotation marks in your string for values that contain quotation marks. For example,

""O'Brians""
petersdaniel@hotmail.com
"If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein

 

[JohnLowell]

I use this for any text that could contain an apostrophe:

Set rs = db.OpenRecordset("SELECT * FROM [TBL ChequeDetails] " & "WHERE Name LIKE " & chr(34) & "*" & Me!Name & "*" & chr(34))

 

[Hargreavesk]

John, Peter,

Thankyou for your help. I have it working now.

Many thanks

Kate

 

[Junior1544]

i just solved this myself this morning... using the save fix as peter suggests! thanks, i just wish i saw this sooner

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.