Challenge including the double quotes to use in Find Method

K

knight00779

Joined
Feb 8, 2009
Messages
15
Reaction score
0
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

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

Want to achive
rs.Find "ContactID=" 33

I have tried
strFind=" " " & strColumn & " " " (the output stored in the strFind variable is not as expected)

Thank you
Regards
Knight
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Double Quotes in C# - Prob something simple but I feel im goingcrazy 12
Too few parameters error when exporting to text file 4
Could not add to Oracle DB with dynamic SQL 4
Find Numeric Criterion in Column & Return the Numeric Value from Row above 6
How can I use add() method from the Form2 to listBox in another form? 5
How to use Find method in dataview for multiple column sort? 1
Type.GetType not finding the dll containing the method I want to use in a late bound context. 5
VBA question: How to extract cell values in different languages 10

Top