Account Balances 9
By Richard Rost 7 months ago
Track Account Balances & Transactions, Part 9
This is part 9 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 are going to learn how to select all of the text in a field automatically whenever the user clicks on it. This way, you don't have to manually select the text inside the field to change the whole value. It will work similar to how Excel behaves when you click on a cell.
Members will be learning how to manage transactions more effectively by marking them as cleared instead of deleting them, a feature which ensures these transactions are archived for future reference. This extends to features such as closing child forms, wherein closing the Account List form would also lead to the automatic closure of the Transactions form. Members will also become familiar with a system that produces a warning message if a negative value is expected and a positive one is entered. Further, they will learn how to expand their use of conditional formatting to include warning and critical balance levels, moving beyond a simple zero balance.
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, select text on click
Subscribe to Account Balances 9
Get notifications when this page is updated