I just move an Access DB from Windows XP to Windows 7 - and it stopped working! Lots of missing references to objects, which I cannot find on the system.
How can I get the references straighten out?
Help most appreciated.![]()
I just move an Access DB from Windows XP to Windows 7 - and it stopped working! Lots of missing references to objects, which I cannot find on the system.
How can I get the references straighten out?
Help most appreciated.![]()
Did you change versions of Access? The most likely cause of your problem would be configuration changes to Access and not anything to do with your version of Windows.
It's generally considered poor programming practice to do this, but there's an option in MS's Visual Basic Studio that lets you use variables without first declaring them. I'd try setting that and see if it helps.
In Visual Basic Studio, go to the Tools menu and then to Options.
In the first Tab there, uncheck "Require Variable Declaration".
If that doesn't help, then you're looking at having to track down each Object manually. . .
Thank you for your quick reply.
No change in Office version (2010). could it be that some options in Office were not installed on the Win7 machine, and this caused the references issue?
BTW, I explicitly declare all variables, so I know that is not an issue.
Also, where are all the ActiveX objects I had on XP? Now I open a form in design mode and get "There is no object in this control", and the list of ActiveX control on teh ribbon is tiny compare to what I had on XP.
I am obviously missing something! Any ideas?
Help would be most appreciated.
Sorry for the delay in responding, but all this stuff comes to my work e-mail so I don't see when someone replies to me after I go home for the weekend
Just about the only thing you can do now is to go through your code and figure out where the missing References are. The easiest way to do this is to just run the code and, every time you get an error, choose "Debug" to see which variable Access can't find. If you don't have a "Debug" option, just hit [CTRL]+[BREAK] once the error pops up to get it.