Kaup, Chester
Chester_Kaup at kindermorgan.com
Tue Aug 7 07:59:37 CDT 2007
I would check for EOF first. You will get an error if you try to move to a record that does not exist. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Tuesday, August 07, 2007 7: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