VBA code from Access 2007 Database not working properly in version 2010.

[canonguy]

My DB was created in Access 2007 but when I run it with Access 2010, it does not work properly and it's missing functions that are available if I run the DB in 2007. The stuff that does not work or show in 2010 use VBA.

 

[dhookom]

Did you attempt to compile the code?
Did you check the references?

Duane
Hook'D on Access
MS Access MVP

 

[missinglinq]

As Duame suggested, when apps run fine on one machine and not on another, or run fine in one version and not when run under a newer version, one the first things you have to think about are missing references.

If you haven't checked for this kind of thing before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

Linq ;0)>


The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[canonguy]

Sorry for responding so late, i've been on holidays. I have compiled the code and the issue is gone. thx