VBA app throwing error in Windows 7 , office 2010 but not in Win XP
I have an app in VBA consisting of many reports, quries, forms and tables.
This .mdb file is linked to another .mdb file(the actual database for the
app). This app was originaly developed in Windows XP.But I have to move
this app to run from a machine which has Windows 7.Now when I run a
particular report in win 7 machine it throws an error.
The expression On Deactivate you entered as the event property setting
produced the following error : A problem occured while application was
communicating with the OLE server or Active X component
When I comment out the Deactivate event from that particualr report, the
error is no more. But the interesting point is, when I use the same .mdb
file to run from a XP machine , it works just fine. I am very much
confused. Any help will be highly appreciated.