Steve Goodhall
steve at goodhall.info
Tue Jan 31 15:33:52 CST 2012
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