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