<

How to Install and Make an Add-in for Access

Posted on
8,411 Points
211 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
This article showcases how to fix basic cloud storage and sync errors in OneDrive for Business on primarily Windows OS workstations, but some of the tips and troubleshooting steps could be easily applied to OneDrive - Personal usage (non-work relate…
I found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use.  Here is how I added one to a Microsoft Access database. Please see the important note at the bottom of this article regarding compati…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month