Section 1: Introduction and Overview
Section 2: Setting Subform Colors
Section 3: Using Queries to Create Year Over Year Comparisons
Section 4: Create Running and Page Totals on Reports
Section 5: Set the Starting Autonumber in a Table
Section 6: Back to Record on Open
Section 7: Design Challenge - The Security Company Call List
-
Overview of the Call List Design Challenge (11:47)
-
Add VBA Code to the Edit Button (11:14)
-
A Function to Test for No Records and Add VBA Code to the Add Button (11:15)
-
Create a Subroutine to Sort the Call List Records (5:01)
-
Add Code to the Delete Button (9:26)
-
Start Building Code for the Change To Combo Box (6:45)
-
Build the LostFocus Sub and Start the AfterUpdate Sub (5:45)
-
Figure Out How to Handle Change To Renumbering (3:39)
-
Create the Decrease Sequence Subroutine (6:45)
-
Create the Increase Sequence Subroutine (7:25)
-
Testing for Errors (8:45)
-
Final Testing and Debugging (8:08)
Section 8: Conclusion
