[AccessD] Access 2003 vs Access 2007 VB Question

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




More information about the AccessD mailing list