ActiveX Calendar control prompts for office installation

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    ActiveX Calendar control prompts for office installation

    Hi everyone,

    I can't remember what causes this bug.

    I'm using an ActiveX calendar control on its own form in an application I designed. It works fine on my system but causes a problem on the clients system. Everytime the command button is clicked to load this form the system tries to reinstall office.

    I know I've come accross this before but I can't remember what causes it. Is this a missing office update?

    Mary
  • JConsulting
    Recognized Expert Contributor
    • Apr 2007
    • 603

    #2
    Originally posted by mmccarthy
    Hi everyone,

    I can't remember what causes this bug.

    I'm using an ActiveX calendar control on its own form in an application I designed. It works fine on my system but causes a problem on the clients system. Everytime the command button is clicked to load this form the system tries to reinstall office.

    I know I've come accross this before but I can't remember what causes it. Is this a missing office update?

    Mary

    If you work in different versions if Access side by side, often the ComCat.dll file gets switched and causes Access to think it doesn't exist. You can try registering that dll on the client system...what version of access?

    J

    Comment

    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387

      #3
      Originally posted by JConsulting
      If you work in different versions if Access side by side, often the ComCat.dll file gets switched and causes Access to think it doesn't exist. You can try registering that dll on the client system...what version of access?

      J
      Its Access 2000 and the client only had the one version of the software on their system that I'm aware of but I'll check with IT. I can talk to the IT Manager but before I get him to go looking for updates or patches I want to be sure of what I'm talking about.

      If this is the problem is there any work around for it or should I just use a different approach to date selection.

      Comment

      • JConsulting
        Recognized Expert Contributor
        • Apr 2007
        • 603

        #4
        Originally posted by mmccarthy
        Its Access 2000 and the client only had the one version of the software on their system that I'm aware of but I'll check with IT. I can talk to the IT Manager but before I get him to go looking for updates or patches I want to be sure of what I'm talking about.

        If this is the problem is there any work around for it or should I just use a different approach to date selection.
        It could be that the client (or his IT staff member simply didn't install that component with the application. Could be something simple like a missing reference. ActiveX components are pretty stable now compared to back when we were using A97. So chances are this one's easy. I'll be curious to know which nails it.
        J

        Comment

        • MMcCarthy
          Recognized Expert MVP
          • Aug 2006
          • 14387

          #5
          Originally posted by JConsulting
          It could be that the client (or his IT staff member simply didn't install that component with the application. Could be something simple like a missing reference. ActiveX components are pretty stable now compared to back when we were using A97. So chances are this one's easy. I'll be curious to know which nails it.
          J
          LOL!

          Me too. I'll double check the references list. But it opens OK if you cancel the installation process which leads me to believe its not a reference.

          Comment

          • puppydogbuddy
            Recognized Expert Top Contributor
            • May 2007
            • 1923

            #6
            Originally posted by mmccarthy
            LOL!

            Me too. I'll double check the references list. But it opens OK if you cancel the installation process which leads me to believe its not a reference.

            Hello Mary, Jeff:

            My advice....save yourself the hassles, and worries about Versioning, ActiveX dll's, referencing, etc. by using a popup Calendar that is a native Access form, like the excellent calendar from Allen Browne that he offers as unrestricted freeware.

            Free popup calendar (month view) for selecting a date in a Microsoft Access database. The calendar is an Access form, so requires no additional VBA references.


            pDog

            Comment

            • MMcCarthy
              Recognized Expert MVP
              • Aug 2006
              • 14387

              #7
              Originally posted by puppydogbuddy
              Hello Mary, Jeff:

              My advice....save yourself the hassles, and worries about Versioning, ActiveX dll's, referencing, etc. by using a popup Calendar that is a native Access form, like the excellent calendar from Allen Browne that he offers as unrestricted freeware.

              Free popup calendar (month view) for selecting a date in a Microsoft Access database. The calendar is an Access form, so requires no additional VBA references.


              pDog
              Thanks pdog I'll check that out. Haven't been on Allen's site in a while. Looks like I'll have to make some time to explore there again. :)

              Comment

              Working...