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

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » using Common Controls in Access VBA (VBA/Access/97)

    Author
    Topic
    WSMikeWoods
    AskWoody Lounger
    September 7, 2001 at 8:32 pm #360091

    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?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WScharlotte
      AskWoody Lounger
      September 7, 2001 at 9:26 pm #541377

      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?

      Reply | Quote
      • WSMikeWoods
        AskWoody Lounger
        September 8, 2001 at 11:46 am #541425

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

        Mike

        Reply | Quote
        • WSjscher2000
          AskWoody Lounger
          September 8, 2001 at 8:22 pm #541467

          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.

          Reply | Quote
          • WSMikeWoods
            AskWoody Lounger
            September 9, 2001 at 7:25 pm #541519

            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

            Reply | Quote
            • WScharlotte
              AskWoody Lounger
              September 10, 2001 at 1:44 am #541550

              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.

              Reply | Quote
    Viewing 0 reply threads
    Reply To: using Common Controls in Access VBA (VBA/Access/97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.