Forum Discussion
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.
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_HepworthSilver Contributor
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?
- ecommerce700Copper ContributorThank 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_HepworthSilver Contributor
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?