<

How to Install and Make an Add-in for Access

Posted on
8,324 Points
124 Views
2 Endorsements
Last Modified:
Published
Experience Level: Intermediate
11:42
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
Learn how to install an add-in for Access. Add-ins can save time, and make your code more accessible. Where does the add-in go?

Do you want to create an add-in? What must it contain? Learn about the USysRegInfo table and what needs to be in it.

The add-ins demonstrated here can be downloaded (free) from:

Tools > Add-in > Document SQL, RecordSource, RowSource
http://msaccessgurus.com/tool/Addin_DocumentSql.htm

Tools > Add-in > Workspace Save and Restore
http://msaccessgurus.com/tool/Addin_Workspace.htm

The add-ins are just ACCDB files that have been renamed to have an ACCDA extension.

Video Steps

1. To install an add-in, run Access as Administrator

2. Open a database

3. Drop down the list under the Add-ins icon on the DATABASE TOOLS ribbon tab

4. Choose the Add-in Manager

5. Choose Add New...

6. Browse to the ACCDA file and click Open

7. Close the Add-in Manager

8. Your new add-in should now be on the Add-ins menu

2
0 Comments
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.
In this short 7 minute video, I show you how to connect your LinkedIn to your Microsoft 365 apps to view in Outlook.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month