Solved

Progress bar issue in MSAccess 2010

Posted on 2014-11-26
6
202 Views
Last Modified: 2014-12-01
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?
0
Comment
Question by:martmac
6 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40466670
What version, 32 bit or 64 bit Office are you running?  The 64 bit version will not run a vast number of activeX controls, including the mscomctl.ocx controls.

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.
0
 

Author Comment

by:martmac
ID: 40466720
Thanks so much for your prompt response, 32bit Windows and 32bit office. I will do that search.
0
 
LVL 26

Expert Comment

by:Nick67
ID: 40469233
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?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40469586
Here is the link to the article I talked about
0
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 500 total points
ID: 40472479
You might have to use the alternate method described in my Access Archon article on this topic:

http://www.helenfeddema.com/Files/accarch181.zip

Here is a screen shot of the alternate progress bar:

Custom progress bar
0
 

Author Closing Comment

by:martmac
ID: 40473209
Thanks a lot this sorts the problem, I gave up on the MS Progress bar.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now