Solved

Progress bar issue in MSAccess 2010

Posted on 2014-11-26
6
220 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

739 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