Challenge including the double quotes to use Find Method

knight00779 · June 28th, 2009, 11:54 AM

Hi

I am using Find Method in Access 2007. Since Find method needs the Column name with double Quotes, Current Challenge am facing is including the double quotes along with the column name
The column name being dynamic taken from variable. Else when hardcoding the column string this works fine.

strColumn = "ContactID="
strValue = 33

Want to achive
rs.Find "ContactID=" 33

I have tried
Opt1. strFind=" " " & strColumn & " " " (the output stored in the strFind variable is not as expected)
Opt2. rs.Find " " " & strColumn & " " " & strValue

Thank you
Regards
Knight

SerranoG · June 29th, 2009, 04:30 PM

In the case of

strColumn = "ContactID="
intValue = 33

Code:

rs.Find strColumn & intValue

In the case of

strColumn = "ContactID="
strValue = "33"

Code:

rs.Find strColumn & "'" & strValue & "'"

and FYI for

strColumn = "ContactID="
dtmValue = Date()

Code:

rs.Find strColumn & "#" & dtmValue & "#"

knight00779 · July 6th, 2009, 05:30 AM

Hi Greg,

Thank you for your response. This worked. I was with a misconception to pass " " with the Fieldname. The first option worked.

Rgrds
Knight

SerranoG · July 7th, 2009, 07:57 AM

Quote:

Originally Posted by knight00779

Thank you for your response.

You're quite welcome. Good luck with your project.