how to find a recordset with ADO

[ythg]

How can i find a recordset with ADO. i already know how to declare the ADO. but when i want to go to the record i want. i have trouble because i need to find a record which have 2 condition to complete.

example like this :

with rst
.find kode = !skode and nk = !nkode

how to declare it so, it can works ..

Thanks

 

[MadJock]

Hi,

Don't have an ADO reference handy, but try looking for .seek and / or .findfirst methods.

Hope this helps,

Graeme website:

http://www.graeme-taylor.co.uk

 

[danvlas]

If kode and nk are numbers:
with rst
.findFirst "kode = " & !skode & " and nk = " & !nkode

If they are text type:
.findFirst "kode = '" & !skode & "' and nk = '" & !nkode & "'"

If they are date type:
.findFirst "kode = #" & Format(!skode,"mm/dd/yyyy&quot & "# and nk = #" & Format(!nkode,"mm/dd/yyyy&quot & "#"

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[MadJock]

sorry, should be like this

.find "[fieldname]='" & strValueToFind & " AND " [fieldName2] = '" & strValueToFind & "'"

.seek would be faster but relies on indexing and is a bit more complex website:

http://www.graeme-taylor.co.uk

 

[danvlas]

MadJock: Seek is awful nowadays. Mainly because it only works with native tables. If you base your code on Seek method and then you split the database, you'll be in trouble...

Regards,

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[cmmrfrds]

In ADO the filter method is the most efficient and easy to use.

rst.Filter = "kode = 'a literal' and nk = " & anumber
' do you processing
'- turn off filter before refiltering.
rst.Filter = adFilterNone
rst.Filter = "kode = 'something else'"

If you have a large ADO recordset, you can add an in memory index before filtering.
rst.("kode&quot.Properties("OPTIMIZE&quot = True

 

[ythg]

Thanks for everyone to help me. but from all your suggestion to use seek. but i don't know how to use seek property.

Or can i use bookmark property? .. if i could, i don't know how to use it.

Thanks again.