[AccessD] Access 2003 vs Access 2007 VB Question

Thanks. That fixed it.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Tuesday, January 31, 2012 3:33 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2003 vs Access 2007 VB Question


  Check your references in VBA.  You most likely set to ADO instead of DAO.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, January 31, 2012 04:21 PM
To: Access Developers discussion and problem solving
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