Suntax for find on a string

[livvie]

Where should I be putting ' s to make this right. It's fine for a number but not a string


rstEst.Find "partname=" & MyPartName

 

[ghudson]

Try...

rstEst.Find "PartName = " & "'" & MyPartName & "'"

Those are single quotes surrounded by double quotes.

 

[Mile-O]

Forget ' - it's not the most robust.

rstEst.Find "PartName = """ & MyPartName & """"


For each ' replace with ""

 

[livvie]

I am getting an arguments are of the wrong type, are out of an acceptab;e range or are in conflict with one another. I though it was because of the string but obviously not. What causes this error.

 

[livvie]

I am getting an arguments are of the wrong type, are out of an acceptab;e range or are in conflict with one another. I though it was because of the string but obviously not. What causes this error.

Seems to work ok with the single quotes

 

[ghudson]

Forget ' - it's not the most robust.

rstEst.Find "PartName = """ & MyPartName & """"


For each ' replace with ""

Access 97 sometimes errors if I do not use the "'" to enclose a text string in VBA.