0. Welcome (4:48)
How To Add Option Explicit and Build Multi Select Filters in Microsoft Access VBA Code
Course overview and recommended prerequisites
1. Missing Option Eplicit (27:25)
Scan Forms, Reports, Modules for Missing Option Explicit & Add Automatically
Why Option Explicit prevents VBA typos
Looping through standard modules
Opening modules with DoCmd.OpenModule
Checking whether a module is already open
Accessing a module with the Modules collection
Closing modules after scanning
Checking whether the VBE was already open
Restoring the VBE window visibility
Scanning declaration lines in a module
Creating a HasOptionExplicit function
Checking forms for missing Option Explicit
Checking reports for missing Option Explicit
Handling Module objects versus form modules
Adding Option Explicit with InsertLines
Automatically fixing missing Option Explicit
2. Multi-Select Filters (35:30)
Build Multi-Select Combo Box Filters Using Multi-Valued Fields
Multi-select combo boxes with multi-valued fields
Creating a multi-valued field lookup table
Binding multi-select combos on a subform
Using a subform to filter its parent form
Reading selected multi-valued combo values in VBA
Building SQL IN() filters from selected values
Filtering by multiple fields with AND or OR
Using aggregate queries for combo box value lists
Handling Null multi-valued field selections
Clearing filter selections when a form closes
Hiding subform borders for a seamless filter UI
3. Fix Declarations (11:23)
Standardize Option Compare & Option Explicit in Every Module
Standardizing VBA module declarations
Preserving Option Compare settings
Adding Option Explicit to modules
Deleting declaration lines in reverse order
Using Module.DeleteLines and InsertLines
Defaulting to Option Compare Database
4. What's Next (3:12)
What Is Next for Microsoft Access Developer Students and Future Course Lesson Planning
Closing remarks and preview of planned future Developer topics.
