How to Install and Make an Add-in for Access
Posted on
8,412 Points
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.
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
0 Comments
Suggested Videos
When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass. In this example a form flashes a message while the stored procedure executes, and then closes itself on…
Not too long ago I wrote this article on doing the same thing in MS Access (https://www.experts-exchange.com/articles/38421/Making-your-Database-More-User-Friendly.html). I found that a similar "Welcome" screen makes Excel worksheets "friendlier" a…
Suggested Courses
Next Video:Windows Insider Preview 19613