.RecordCount with query ???

[marco02]

Can I retrieve directly the number of recordset in a query without looping through the entire recordset ?

Why doesn't the .RecordCount work on a query ?

Is there a similar property for a query ?

thanks so much,

marco

 

[kevinclark]

Some cursors do not support recordcount

If your using ADO (See link -->

http://www.xtremecomp.com/tips/xttip13.htm).

If using DAO you can try moving to the last record and then do a record count

MyRS.Movelast
Msgbox MyRS.RecordCount - 1
MyRS.MoveFirst

 

[Guest_imported]

There is one more reason .If you are using ADO and if you not set the "cursorlocation" property to "adUseClient" then it will not return the number of records.
Another way to do is using SQL query.
eg. Select count(*) from table_name;