asked on Microsoft Access form, Getting Error " There is no object in this control "
Issue:
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?
Attempted Fixes:
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?!
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?
Attempted Fixes:
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?!
Microsoft AccessVisual Basic ClassicMicrosoft Office
Last Comment
Russell Kozora
Just curious, ...what functionality are are using this dll for?
Many times the same functionality exists in Access' native controls...
Many times the same functionality exists in Access' native controls...
ASKER
Thanks for the responses..
The first link does not seem to be working..
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx
I'm not actually sure if we are using FM20 - but I do know the reference that is missing is 'Microsoft Forms 2.0 Object Library' which I don't believe is not a native control?
Either way - the objects that are missing a reference are just simple buttons.
That we have disabled on the form, and then once a proper password is entered in VBA we ENABLE them.
So if there is a different object type, besides the buttons that the form was setup to use previously with Forms 2.0.. Then we would be willing to change all of those buttons to a new method. . . I am just unaware of such button?
Hope that makes sense. .
The first link does not seem to be working..
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx
I'm not actually sure if we are using FM20 - but I do know the reference that is missing is 'Microsoft Forms 2.0 Object Library' which I don't believe is not a native control?
Either way - the objects that are missing a reference are just simple buttons.
That we have disabled on the form, and then once a proper password is entered in VBA we ENABLE them.
So if there is a different object type, besides the buttons that the form was setup to use previously with Forms 2.0.. Then we would be willing to change all of those buttons to a new method. . . I am just unaware of such button?
Hope that makes sense. .
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Because the issue is some what related to a MS forms.
We had to deal with an old MS word document form there you can't able to type into it. Solution for that problem was to uninstall this particular MS office security update. Keeping that in mind I applied the same solution and it worked.
We had to deal with an old MS word document form there you can't able to type into it. Solution for that problem was to uninstall this particular MS office security update. Keeping that in mind I applied the same solution and it worked.
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx
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:
http://support.microsoft.com/kb/224305
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.