Charlotte Foust
cfoust at infostatsystems.com
Tue Aug 7 11:40:01 CDT 2007
Nope, with an ADO recordset, check for EOF and BOF (empty recordset). Don't try a movefirst otherwise. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Tuesday, August 07, 2007 5:53 AM To: Access Developers discussion and problem solving Subject: [AccessD] Recordset question Given an ADODB recordset that has been opened, should one moveFirst and then check for EOF, or vice-versa? Will it error if you moveFirst and there are no records in the set? TIA, Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com