Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how can i return a recordset length? 1
- Thread starter Kicket
- Start date
-
1
- #3
CajunCenturion
Programmer
It depends on what type of Recordset (ADO or DAO) and whether or not your provider supports such properties, but you can look at the .RecordCount property, or the .AbsolutePosition (may be 0 or 1 based depening on provider if supported) property, or you can loop thru and count them.
That being said, these properties may not work will all cursor types either. Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
That being said, these properties may not work will all cursor types either. Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
- Thread starter
- #4
- Thread starter
- #5
- Status
