Section 1 - Introduction
Section 2 - Using the VBA Editor and Standalone Modules
Section 3 - Dealing with Errors and Debugging
Section 4 - Replace the To Orders and To Customer Macros
Section 5 - Make the To Orders Button work from the Subform
Section 6 - Using Custom Message Forms
Section 7 - Add Sorts to the Customer List Form
-
Intro to the Customer List Form (6:00)
-
Create a Sort Subroutine for the First Name Field (6:13)
-
Create the DoSort Subroutine for All the Fields to Use (8:03)
-
Add “Sticky” Capability to the Sort (11:57)
-
Add keyboard shortcuts for sorting (6:40)
-
Synchronize the Forms and Create an Error Handler (17:09)
Section 8 - Add Filters to the Customer List Form
-
Add the State and City Filters to the CustomerList form (11:16)
-
One subroutine to handle all the filters (17:14)
-
Finish setup on the combo boxes and Clear Buttons (12:00)
-
Finish Building the BuildFiltStr Subroutine (7:26)
-
Debug and Synchronize the Customer form with the Filters (12:34)
-
Activate the Clear Filter button on the Customer Form (4:42)
