Curriculum
Section 1 - Introduction
Available in
days
days
after you enroll
Section 2 - Using the VBA Editor and Standalone Modules
Available in
days
days
after you enroll
Section 3 - Dealing with Errors and Debugging
Available in
days
days
after you enroll
Section 4 - Replace the To Orders and To Customer Macros
Available in
days
days
after you enroll
Section 5 - Make the To Orders Button work from the Subform
Available in
days
days
after you enroll
Section 6 - Using Custom Message Forms
Available in
days
days
after you enroll
Section 7 - Add Sorts to the Customer List Form
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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)