Returning the Number of Rows in a Recordset

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

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.
 
It depends what type of recordset you're working with. Look up "recordcount"
in the vb Editor Help.

HTH,
Shockley
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO retrieval from close workbook-data type issue 2
Syntax to reconnect a disconnected recordset? 4
Reg: Incorrect RecordCount when opened a Excel sheet in ADO Recordset 4
CopyFromRecordset with Filtered ADO recordset 2
VBA question: adding a row to worksheet from recordset row 1
sql stored procedure results in a recordset questions 2
ADO recordset 2
Use VBA to Populate Listbox from Open Spreadsheet 4

Back
Top