Track Account Balances & Transactions, Part 7

This is part 7 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 fix a bug discovered by a student. Then we're going to change the background color of some of the fields if they have focus, and always change the background color of the SortOrder field if the focus is in that row. We're going to add an "are you sure" to the Cancel button on the account detail form in case someone hits ESC by accident. We're going to add the capability to put equations in the Pending field. We'll need to make some adjustments to the Conditional Formatting.

Members

Members will learn how to optimize the account list sorting with a recordset. This will make it run much faster and more efficiently.

•  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!

Prerequisites

• Account Balances 1: https://599cd.com/AccountBalances1
• Account Balances 6: https://599cd.com/AccountBalances6
• Highlight Row: https://599cd.com/HighlightRow
• Math in Fields: https://599cd.com/MathInFields

Suggested Template

• Account Balances Template: https://599cd.com/Balances

Links

• On Current Event: https://599cd.com/OnCurrent
• Dirty: https://599cd.com/Dirty
• Update Queries: https://599cd.com/UpdateQ

Member Links

• Using Recordsets: https://599cd.com/Recordset

Recommended Courses

• Access Developer Courses: https://599cd.com/Developer

Next Video

• Account Balances 8: https://599cd.com/AccountBalances8

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 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, On Dirty Event, Dirty Property, change background color of field on focus, change background color of another field on focus, are you sure cancel button, equations in fields in continuous forms, optimize sort with recordset