XL2K: ADO's Find method (once again.)

[Mike Mertes]

Maybe no one understood what I was asking before, so let me try this again:

In this example:

recordset.Find "FIELD = 'MyVar'"

What is the correct syntax for replacing the literal string, "MyVar," with a
variable?
I've tried every way I could think of, and I always get a syntax error as
the result.

For instance:

Dim MyVariable as String
recordset.Find "FIELD = MyVariable"

does not work.

TIA,
Mike

 

[merjet]

Hi Mike,

In this example:

recordset.Find "FIELD = 'MyVar'"

What is the correct syntax for replacing the literal string, "MyVar," with a
variable?
I've tried every way I could think of, and I always get a syntax error as
the result.

A workaround is to fully specify the argument in advance, e.g.

Dim str As String
' if MyVar is a String:
str = Chr(34) & "Field ='" & Chr(34) & MyVar & Chr(34) & "'" & Chr(34)
' if MyVar is numeric:
str = Chr(34) & "Field ='" & MyVar & "'" & Chr(34)
rs.Find str

HTH,
Merjet

 

[Myrna Larson]

I don't know if this will work, but try

"FIELD = '" & MyVariable & "'"

or, a trick that I often use

recordset.Find Replace("FIELD = 'MyVar'", "MyVar", MyVariable)