Track Account Balances & Transactions, Part 4

This is part 4 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 recalculate the actual balance and change the DateUpdated field any time one of the other fields is edited. We'll create a DoRecalc event handler function and requery the data in place. We'll set any of those fields to zero if the user deletes them. We'll also run our DoRecalc if a field is double-clicked. We'll add the pending value to the balance on double-click. We'll work on our tab stops, and add some conditional formatting to the DateUpdated field so that we can see which accounts haven't been updated recently (current, week, month). 

Members

Members will fix the DoStartup routine which I broke last week. We're going to add back in that routine to check for linked tables, but also check for accounts. And we'll upgrade our StatusBox function to change red if it's an urgent error.

•  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 3: https://599cd.com/AccountBalances3
• Requery in Place: https://599cd.com/RequeryInPlace
• Event Handler: https://599cd.com/EventHandlerFunction

Suggested Template

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

Recommended Courses

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

Next Video

• Account Balances 5: https://599cd.com/AccountBalances5

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, recalculate in place, requery in place, tab stops, conditional formatting if date old, check status of linked tables