P
Peter
I use ADO to open a cursor. Can I use DLookup to find the first record in the cursor?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
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
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
the cursor?Peter said:I use ADO to open a cursor. Can I use DLookup to find the first record in
P
Peter
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.
B
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.
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.
not be the first row of the recordset. It can be any row.Peter said:Thanks. The purpose I want to use DLookup is because the target row may