ACTEBS
actebs at actebs.com.au
Tue Oct 19 08:05:52 CDT 2004
Andy, You're a star. Thanks to Gustav and Rocky for their suggestions. For the life of me I couldn't come up with that. I love this list! Vlad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey Sent: Tuesday, 19 October 2004 10:44 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] DAO Recordset/Database is Open? Hi Vlad How about: If rst Is Nothing Then -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: Access Developers discussion and problem solving <accessd at databaseadvisors.com> To: Access Group E-mail <accessd at databaseadvisors.com> Subject: [AccessD] DAO Recordset/Database is Open? Date: 19/10/04 12:26 > > Guys, > > Does anyone know how, using DAO, to check whether a recordset is currently open and also whether the database is currently open. In ADO you can use "State", but there seems to be no equivalent in DAO... > > Any ideas? > > Vlad > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > > > ________________________________________________ Message sent using UebiMiau 2.7.2 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com