Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Access VBA Developer's Course
Section 1 - Introduction
Introduction (3:53)
Section 2 - Using the VBA Editor and Standalone Modules
Overview of VBA Editor & Modules (13:09)
Custom Form Subroutines and Using Comments (6:05)
Modifying the Custom Form Subroutine (7:50)
Creating a Shared Module Subroutine (8:18)
Section 2 Quiz
Section 3 - Dealing with Errors and Debugging
What to do when you have a Compile error (5:32)
What to do when you have a Runtime Error (3:25)
Using Breakpoints and Tracing Programs (7:56)
Finding and Using the BREAK Key (3:12)
Section 3 Quiz
Section 4 - Replace the To Orders and To Customer Macros
Resource Files for Sections 4 and 5
Replace the To Orders Macro (11:53)
Replace the To Customer Macro and Add a Test to the To Customer Button (8:07)
Section 5 - Make the To Orders Button work from the Subform
Step 1 – get the Order Number (12:21)
Step 2 - Make the Order form Find the Order, then Return (6:27)
Step 3 - Make the customer form go to the Subform record (4:55)
Step 4 - Figure out when to reset the TempVar (11:00)
Step 5 - Test and Fix the Last Errors (10:45)
Section 6 - Using Custom Message Forms
Start Using MyMsgBox (9:46)
Start Using MyYesNoBox (7:46)
Using the Immediate Window (4:23)
Introduction to the Keydown Event (9:03)
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)
Teach online with
Step 3 - Make the customer form go to the Subform record
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock