Article ID: 230888 - View products that this article applies to.
This article was previously published under Q230888
When you run or open a Microsoft Visual Basic for Applications macro with a UserForm, the following error message appears:
This may be followed by these error messages:
System Error &H80004005 (-2147467259). Unspecified error.
Out of memory
Run-time error 7. Could not find the specified object.
This problem occurs when the following conditions are both true:
NOTE: If this control is added to an Access form separate from the Visual Basic Editor, the following error message may appear:
This is followed by:
Microsoft Access can't communicate with the OLE server.
The OLE server may not be registered.
To register the OLE server, reinstall it.
Closing that error removes the control from the Access form.
There is not enough free memory to update the display. Close unneeded programs and try again.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Because the UserForm cannot be opened after this problem occurs, the only remedy is to remove the UserForm in the Visual Basic Editor and not use this control on a replacement UserForm.
To remove a UserForm in the Visual Basic Editor, use the following steps:
Article ID: 230888 - Last Review: October 11, 2006 - Revision: 4.2