Hi Terence,
Unless you use a cursor that builds the entire recordset in advance
there's no way to get a record count because the records haven't been
retrieved yet. Even with a scrollable cursor, you'll usually have to execute
an rs.MoveLast followed by an rs.MoveFirst in order to fully populate the
recordset so that a count can be retrieved.
This can be a pretty resource intensive operation. If you really need to
know in advance exactly how many records you're going to get back, it's
often better to do a separate SELECT COUNT(*) query using the conditions in
your final SQL statement. The result of this query will be the number of
records returned when you execute the full SELECT statement.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
