Introduction and Overview
  • Introduction
  • Important NOTE on DOWNLOADABLE RESOURCES
Setting Subform Colors
  • Overview of Setting Subform Colors
  • Setting Subform Colors with Access VBA
  • Finish Placing Codes and Final Testing
Using Queries to Create Year Over Year Comparisons
  • Demonstration and Overview of the Objective
  • Create the Query that Makes the SalesByQuarter Table
  • Start Building the GetLastYear Query
  • Add the Sales Difference to the GetLastYear Query
Create Running and Page Totals on Reports
  • Create Running and Page Totals
Set the Starting Autonumber in a Table
  • NOTE on modification to the way Access works when appending records
  • Set the Starting CustID and Append Customer Data
Back to Record on Open
  • Overview of the BackToRecord Database
  • Open on Customer Form and Record Values on Exit
  • Modify the Customer Open Subroutine to Use the values in the table
Design Challenge - The Security Company Call List
  • Overview of the Call List Design Challenge
  • Add VBA Code to the Edit Button
  • A Function to Test for No Records and Add VBA Code to the Add Button
  • Create a Subroutine to Sort the Call List Records
  • Add Code to the Delete Button
  • Start Building Code for the Change To Combo Box
  • Build the LostFocus Sub and Start the AfterUpdate Sub
  • Figure Out How to Handle Change To Renumbering
  • Create the Decrease Sequence Subroutine
  • Create the Increase Sequence Subroutine
  • Testing for Errors
  • Final Testing and Debugging
Conclusion
  • Conclusion and Overview of What We Covered
  • BONUS Lecture! Learn Even More!