ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Returning the Number of Rows in a Recordset (https://www.excelbanter.com/excel-programming/281202-returning-number-rows-recordset.html)

Alex[_14_]

Returning the Number of Rows in a Recordset
 
Hey everyone,
I cant seem to get the RecordCount Function to work...
I always get -1 as the answer even when the recordset is
full. How can I get the quantity of rows from my
recordset?

Alex.

shockley

Returning the Number of Rows in a Recordset
 
It depends what type of recordset you're working with. Look up "recordcount"
in the vb Editor Help.

HTH,
Shockley


"Alex" wrote in message
...
Hey everyone,
I cant seem to get the RecordCount Function to work...
I always get -1 as the answer even when the recordset is
full. How can I get the quantity of rows from my
recordset?

Alex.




Phobos

Returning the Number of Rows in a Recordset
 
Post your code, we're not psychic.

P


"Alex" wrote in message
...
Hey everyone,
I cant seem to get the RecordCount Function to work...
I always get -1 as the answer even when the recordset is
full. How can I get the quantity of rows from my
recordset?

Alex.





All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com