Hello! I'm creating an aplication a

[Gunga]

Hello! I'm creating an aplication and when I use a 'find method'(rsRecSort.Find mSql) it rases this error: 'Compile Error: Method or data member not found.' I'm not sure of what Reference or Component must I include once I've tried almost all.

More: I'm handling a MSACCESS2000 database, and ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=P:\srbr\simma_sd.mdb"
ADODB.Recordset
ADODB.Connection

 

[CasperTFG]

what is mSQL equal to?

Also in your find the syntax if I remember is like.

rsRecSort.Recordset = SET YOUR RECORDS

If rsRecSort.RecordCount > 0 then
rsRecSort.MoveFirst
rsRecSort.Find "Col1 = 10"
End If

If rsRecSort.EOF then
MsgBox "Not found"
Else
MsgBox "Record Found"
End If
Craig, mailto:sander@cogeco.ca

Si hoc legere scis, nimis eruditionis habes