By Richard Rost 11 months ago
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 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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Database Launcher
Get notifications when this page is updated