Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    using Common Controls in Access VBA (VBA/Access/97)

    This is my first post, so go easy with me! I'm developing an Access 97 database and want to use some common controls in my VBA code (the file open dialog and a progress bar). Whenever I try to use these, or almost any of the extra tools on the scrolling list available from the toolbox, I get an error message saying that "The OLE server isn't registered. To register the OLE server, reinstall it." I thought I had installed everything in Office 97, and I cannot find this in the knowledgebase. Any idea what is going wrong?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: using Common Controls in Access VBA (VBA/Access/97)

    Unless you have the Office Developer's Edition (or VB Professional), you don't have a license for the ActiveX controls. Could that be your problem?
    Charlotte

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using Common Controls in Access VBA (VBA/Access/97)

    Yes, that would be the problem. I didn't know about the licensing restriction. Thanks for the quick response Charlotte.

    Mike

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: using Common Controls in Access VBA (VBA/Access/97)

    It's somewhat mysterious to me why, if I can redistribute these controls with a template and the user then can use them in their own userforms, MS bothers with the limited distribution in the first place. In fact, if you were to snoop around the MS site, you could not only find all of the recent ActiveX controls available for instructions on how to register them using a menu choice in Access. (The same command is on the end of the Control Toolbox toolbar in Word and Excel, at the bottom of the list of already-registered ActiveX controls.) Have they gone mad with contradiction? Maybe, but that is for MS to decide as the copyright owner. Just because something is on the Internet does not mean it is licensed, and if you want to comply with the license and do not own VB or Office Developer, you must receive the controls as part of a VB or VBA solution from someone who does.

  5. #5
    New Lounger
    Join Date
    Mar 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using Common Controls in Access VBA (VBA/Access/97)

    Thanks for the info. Unfortunately I'm doing the development on my work PC, and I'm not allowed to install stuff on that. If it isn't part of the standard Office install, I can't use it. Of course, I understand that you weren't encouraging me to use the controls without proper licensing, no matter how daft the restrictions are!

    Mike

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: using Common Controls in Access VBA (VBA/Access/97)

    Get them to buy you the Developer's Tools for Office 97 and you'll have a license to both use and distribute those controls.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •