Acc2010 The object you referenced ... isn't an OLE object
Posted on 2011-09-14
I'm trying to run our Acc 2003 database application in Acc 2010. I have not converted the database, just run it in Acc2010.
Seems to work fine, but when closing a print preview I get
"The object you referenced in the Visual Basic procedure as an OLE Object isn't an OLE object"
The ONClose property runs a sub macro which uses a SetValue command to set a form (from which the report preview was opened) to visible.
Before the report preview was opened the form in question had it's visible value set to no (so it is still open) but hidden.
Worked fine in Acc2003.
So has the syntax changed or dependencies for setvalue on form objects?
A references issue?
These references are loaded (none show MISSING):
Visual Basic for applications (vbe7.dll)
Microsoft Access 14.0 Object Library
OLE Automation (STDOLE2.TLB)
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Object 2.5 Library
Microsoft OLE DB Service Component 1.0 Type Library
Any help greatly appreciated!