asked on Progress bar issue in MSAccess 2010
I have a problem that is driving me insane relating to a progress bar on a form that has suddenly decided it doesn't want to play. The reference to mscomctl.ocx exists in System32 and is referenced in the VBA. I have also tried to register it manually using regsrv32 and it shows are registering successfully. However when I open the form I receive a message telling me
There is no object in this control.
When I look at the form in design view, the progress bar is there but empty. If I try to add another progress bar from the ActiveX list, I then get a message saying;
There was a problem accessing a proper or method the OLE object
I have tried decompiling and no joy. What is frustrating is that the Common control object is there in references and appears to be registered correctly.
Can anyone offer any ideas?
There is no object in this control.
When I look at the form in design view, the progress bar is there but empty. If I try to add another progress bar from the ActiveX list, I then get a message saying;
There was a problem accessing a proper or method the OLE object
I have tried decompiling and no joy. What is frustrating is that the Common control object is there in references and appears to be registered correctly.
Can anyone offer any ideas?
Microsoft Access
Last Comment
martmac
ASKER
Thanks so much for your prompt response, 32bit Windows and 32bit office. I will do that search.
ActiveX controls can be flakey.
What's worth a shot is to copy the name of the control.
Flip to Design View
Delete the control
Recreate it.
Name it to the name of the original control
Test.
Mine's a third-party control, but occasionally, it'll flake.
Now, your problem sounds a little more serious, and it doesn't sound like you can do what I suggested on that particular computer
Question: Do you have another computer with the right version of Access on it to attempt the above procedure? And will it work?
What's worth a shot is to copy the name of the control.
Flip to Design View
Delete the control
Recreate it.
Name it to the name of the original control
Test.
Mine's a third-party control, but occasionally, it'll flake.
Now, your problem sounds a little more serious, and it doesn't sound like you can do what I suggested on that particular computer
Question: Do you have another computer with the right version of Access on it to attempt the above procedure? And will it work?
Here is the link to the article I talked about
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
Thanks a lot this sorts the problem, I gave up on the MS Progress bar.
I'm on my iPhone, but search the EE articles on 'progress bars', i wrote an article and have included code for a progress bar i use all the time.