Forum Discussion

ecommerce700's avatar
ecommerce700
Copper Contributor
Aug 17, 2024

Add-Ons for Access 2019 (for PC)

Hello,

Today I search for some add-ons because there are none into my installed office 2019. So, I try it within Acces 2019 at settings, management. Oops... empty and nothing there to install.

Can anyone tell me how to get this add-ons into my system?
In previous Office (2007, 2009, 2013 and so on) they are installed at first installation.

Where or how can I get these COM and ACCESS add-ons???

By example: Analysis Toolpak, Analystis Toolpak - VBA, ASAP Utilities, Euro Currency Tools, Solution Add-Ons.

Thamks in advanced for your suggestions and help.

 

  • ecommerce700 

    Most of those things you list are for Excel, not for Access. E.g. the Analysis Toolpak.

    VBA is already part of Access. It's not an add-in. In fact, it's part of all Office applications, including Excel, Word and PowerPoint, as well.

     

    Also, I'm afraid the term " ... settings, management ... " doesn't quite ring a bell. Where do you find that?

     

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    ecommerce700 

    Most of those things you list are for Excel, not for Access. E.g. the Analysis Toolpak.

    VBA is already part of Access. It's not an add-in. In fact, it's part of all Office applications, including Excel, Word and PowerPoint, as well.

     

    Also, I'm afraid the term " ... settings, management ... " doesn't quite ring a bell. Where do you find that?

     

    • ecommerce700's avatar
      ecommerce700
      Copper Contributor
      Thank you kindly for your response.
      You are right, but because a VBA code does not work, I started to have doubts. It's about this one: =IIf([veld10]<"B";QBColor(12);QBColor(10)).
      The color does not change at all but the same code works in another form of the same file.
      About the term 'settings': In Access via the toolbarbutton "File, Options, Add-ins", you can add or remove the add-ins under 'Manage' at the bottom of the screen. However, there is nothing on my PC, so I started to doubt whether something was wrong. Hence my message to the community.
      • George_Hepworth's avatar
        George_Hepworth
        Silver Contributor

        ecommerce700 

        Thanks for clarifying. The option is "Manage" under Add-ons. 

         

        If your expression does not work, it could be a syntax error. Where is the Function QBColor() defined?

         

Resources