Kaup, Chester
Chester_Kaup at kindermorgan.com
Tue Jan 31 15:58:23 CST 2012
It was a reference problem. Fixed now. Thanks to everyone. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Goodhall Sent: Tuesday, January 31, 2012 3:34 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2003 vs Access 2007 VB Question It might be a difference in database default settings. How are RSArea1 and RS4 defined? Steve Goodhall, MSCS, PMP -----Original message----- From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Tue, Jan 31, 2012 21:21:55 GMT+00:00 Subject: [AccessD] Access 2003 vs Access 2007 VB Question I moved a database from access 2003 to access 2007. The following statement compiles fine in Access 2003. In access 2007 it generates an error of Compile Error Method or Data Member not Found. What needs to be different ? Set RSArea1 = RS4.OpenRecordset Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com