[AccessD] Help with syntax please....OpenRecordset

Charlotte Foust cfoust at infostatsystems.com
Thu Oct 14 12:19:06 CDT 2004


It also depends on the type of recordset and the location (client or
server).  An ADO recordset may simply return a -1, meaning that yes,
there are records.

Charlotte Foust


-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net] 
Sent: Thursday, October 14, 2004 9:19 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Help with syntax please....OpenRecordset


Some recordsets support the RecordCount property, some don't. Those that
do don't require the move through the records to get a count. Just refer
to the RecordCount property. Just wrote an article on it for Inside
Microsoft Access -- should be out this winter sometime. 

Susan H. 

Mmmzzz don't wanna be fuzzy but one remark about the codesample though
just in case others wanna use it... To use a recordcount if I remember
well, you should always do a rs.movelast and a rs.movefirst first to
populate the recordset and get a reliable recordcount.


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list