When opening an Microsoft Access form, user receives a number of 'There is no object in this control' prompts which makes the form unusable.
The Cause (as we know it):
We installed a newer Microsoft project on the affected PC
And this caused the Active X reference to buttons on the form to be missing in some way?
If we go into VB Code / Tools / References
• Nothing shows up as ‘Missing’
• But within the references we browsed out to add FM20.dll in System32 (Microsoft Forms 2.0 Object Library)
• After we did that we recompiled the code: VB Code / Debug / Compile
On the affected PC’s – we are actually no longer able to add any Microsoft Forms 2.0 Objects without getting an error.
So – we are looking for a solution to this reference issue?!
I realize that for Excel, but it deals with the FM20.dll issue.
Also note that FM20.dll is NOT redistributable, but is instead installed with several components. See this article:
Long term, you really should STOP using external files. If you find that the Access interface does not provide you with sufficient native controls, then you should consider moving to a different development platform.