Create a Microsoft Access Database Launcher

In this Microsoft Access tutorial I'm going to teach you how to use one database to open another using the FollowHyperlink command. We can effectively create a database switchboard which is a database that opens other databases. We'll also see how ChatGPT handles this issue.

Jan from Aurora, Colorado (a Gold Member) asks: I've got two separate Microsoft Access databases that I have to work with. One contains my customers and the sales guys have to use it. The other includes mostly accounting information and my list of vendors and such. The issue is that sometimes the sales guys have to look at the vendor information, and I of course need to use both databases. I don't want to merge these into one database as it's very complicated. Is there a way to just click a button and switch to the other database?

Members

Members will learn how to make a list box containing your database files and launch them that way instead of hard coding them into buttons. We can also use this technique with other objects too and not just database files. You can open spreadsheets, documents, and more.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Pre-Requisites

• Intro to VBA: https://599cd.com/IntroVBA
• Follow Hyperlink: https://599cd.com/FollowHyperlink

Links

• Database Password: https://599cd.com/DatabasePassword
• Simple Security: https://599cd.com/SimpleSecurity - Ext Cut Password Box

Recommended Courses

• Access Developer 39: https://599cd.com/ACD39 - More with FollowHyperlink
• Security Seminar: https://599cd.com/Security

Member Links

• Disable Warnings Registry Hack: https://tinyurl.com/2g54pk8k
• Shell Execute 64-bit: https://599cd.com/ShellEx
• ABCD Core Part 5: https://599cd.com/ABCD5
• List Items Edit Form: https://599cd.com/ListItemsEditForm

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, master database, database switchboard,  Can you link multiple Access databases, How to Link One Access Database to Another, combine databases, how to connect to multiple access databases, shellex, shellexec