DLookup in ADO codes

[Guest]

I use ADO to open a cursor. Can I use DLookup to find the first record in the cursor?

 

[Kailash Kalyani]

In a given recordset you can easily go to the first record by using the
recordset's movefirst method.
Try reviewing the MSDN for the recordset object
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjodbrec.asp

Hope that helps.

--
Kailash Kalyani
MEA Developer Support Center
ITWorx on behalf of Microsoft EMEA GTSC

I use ADO to open a cursor. Can I use DLookup to find the first record in

the cursor?

 

[Guest]

Thanks. The purpose I want to use DLookup is because the target row may not be the first row of the recordset. It can be any row.

 

[Brendan Reynolds]

The answer is no, Peter, the second argument ("domain") to the DLookup
function must be the name of a table or query, it can not be a reference to
a recordset. Recordsets have their own methods of searching and filtering
instead: Find, Seek, and Filter for example.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

Thanks. The purpose I want to use DLookup is because the target row may

not be the first row of the recordset. It can be any row.