Hi folks,
I?m developing a simple, single user database app in Access 2000 using ADO
2.1. I?m opening a single recordset using a dynamic cursor
(adOpenDynamic). Seems that dynamic cursors don?t support
the .AbsolutePosition, .Recordcount, or .Bookmark properties. Problem is,
after running the Find method, if the current record is the first or last
record of the recordset, how do I tell my code that (If???Then). If Find
happens to return the first or last, I want to disable my previous or next
command buttons, respectively, to avoid BOF/EOF errors.
Should I use a different cursor? Or maybe the recordset index number? I
can get the record count simply by looping through the record set, but I
can?t figure out how to identify the current record as the first (or last)
record (if it happens to be).