[AccessD] Office 2010

[Kaup, Chester]

I did the search and replace adding DAO to the Dim statement for Database and Recordset.

The dbOpenTable in the following line generates the message "Compile Error   Cannot find project library". I am not expert enough to know how to fix this. Your assistance appreciated.

Set Myds = MyDb.OpenRecordset("tbl One Manifold Production for a Time Period", dbOpenTable)


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Wednesday, November 04, 2015 6:14 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Office 2010

It used to be that if you had ADO and DAO both referenced in the check box list, then the ORDER of the listing mattered, and DAO should come first. Basically ADO and DAO used the same names for some objects.

It is good habit to always use the prefix anyway, whether forced to or not.

On 11/4/2015 3:27 PM, Kaup, Chester wrote:
> My office computer recently got upgraded from Office 2007 to Office 2010. In my database in the code module I have Dim mydb as DAO database. Office 2010 seems to want me to put DAO in front of every recordset dim statement. EX Dim RS1 as DAO.Recordset. Is there a better way than having to do this for the entire database?
>
> Also since the calendar control no longer exists what is a good solution?
>
> Thank you for your thoughts.

--
John W. Colby

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com