|
||||||
Account Balances 3 By Richard Rost 2 years ago Track Account Balances & Transactions, Part 3 This is part 3 of my Microsoft Access Account Balances tutorial series. In this series we will build a database to track your account balances and daily transactions. Today we're going to split the database into front-end and back-end (table) files to make it easy to switch which "company" of data you're working with. I'm mostly doing this for me so I can switch between my actual data and the class sample data, but you can use it as well if you want to keep data for multiple companies, people, etc. We're also going to pretty up the Main Menu. MembersMembers will learn how to relink the tables automatically with some VBA by simply having the user select the company name from a combo box on the main menu. The code will handle all the magic. 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! Prerequisites
Suggested Template
Links
Recommended Courses
Next Video
Keywordsaccess 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, split database, relink tables automatically with vba, select backend file from list
|
||||||||||||||||||||||||||||
| |||
Keywords: TechHelp Access split database, relink tables automatically with vba, select backend file from list PermaLink Account Balances in Microsoft Access, Part 3 |