Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: ADO: Position of records in recordset


Message #1 by "Bob Bedell" <bdbedell@m...> on Sun, 6 May 2001 15:56:12
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).


  Return to Index