Forum Discussion
ecommerce700
Aug 17, 2024Copper Contributor
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 ...
- Aug 18, 2024
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
Aug 18, 2024Copper 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.
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
Aug 18, 2024Silver 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?