Access 2007 Error
Posted on 2012-03-18
When I try to run a macro SETPROPERTY to set Visible = 0 on a control I get an error as follows:
"A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control." It then goes on to say I need to restart the OLE server outside of Microsoft Access.
This macro ran fine previously. Now it chooses to fail for no reason. The macro runs and it only fails with this error when it attempts to run the SETPROPERTY line. Other commands prior to the SETPROPERTY run fine. Tried rebooting but no luck.
Help is appreciated.