0. Welcome (7:13)
Microsoft Access Recordset Clone Parts 4 Through 7 Course Overview and Introduction
Improving reusable RecordsetClone searches
Handling numeric-looking text search values
Optional data type parameters in VBA
Creating and using VBA enumerations
Processing only visible filtered records
Creating follow-up records for selected records
Deleting filtered records safely
Using RecordsetClone in subforms
Navigating subform records with bookmarks
Comparing Recordset and RecordsetClone behavior
RecordsetClone filters, sorting, and new records
Building a reusable Clone Navigator class
Adding reusable form search and navigation
1. RecordsetClone 4 (13:10)
Improve Our Record Search Function with Enums and Data Type Controls
Creating a reusable go-to record-by-value function
Fixing issues with text fields that contain only numbers
Using optional parameters to control data type
Forcing specific data types in VBA functions
Introduction to enumerations (enums) in VBA
Defining a custom enum for search data types
Implementing enum-based value type control in functions
Using IntelliSense with custom enums
Forcing value type detection: auto, text, number, date
Building criteria strings based on forced data type
Handling numeric-looking text values in record searches
Updating function calls to specify data type when needed
2. RecordsetClone 5 (14:34)
Use RecordsetClone to Identify Visible Records for Inserts, Updates, and Deletes
Using recordset clone as a filtered selection list
Identifying user-selected records with recordset clone
Separating record selection from record processing
Creating related records using SQL based on selected records
Executing SQL statements to insert related records
Error handling when executing SQL in Access
Counting and displaying records processed
Why not to edit or delete records directly in a recordset clone
Using SQL DELETE to remove selected records
Avoiding cursor issues with direct recordset deletes
Turning off form filters after processing
Restoring data after deletions
Advantages of separating selection and processing logic
Practical examples of bulk updates, inserts, and deletes using SQL
3. RecordsetClone 6 (18:16)
RecordSetClone in Subforms, Me.Recordset vs RecordSetClone, and Gotchas
Using Recordset Clone with subforms
Searching records inside a subform
Me.Recordset vs Me.RecordsetClone differences
Referencing RecordsetClone in a subform
Building a subform for related records
Creating a search box for subform navigation
Searching visible (filtered) records in a subform
Understanding subform object naming in Access
Navigating to a matching subform record using Bookmark
Looping through records with Me.Recordset vs RecordsetClone
Performance impact of using Recordset vs RecordsetClone
Behavior of record pointer with Recordset vs Clone
RecordsetClone and the effects of filters and sorting
Handling new (unsaved) records with RecordsetClone
DAO vs ADO RecordsetClone in Access forms
4. RecordsetClone 7 (16:00)
Encapsulating RecordsetClone Logic in a Reusable Class Module
Building a reusable class module for recordset clones
Declaring and using a private form object in a class
Attaching a form to a class module for navigation
Creating a Find method in the class module
Building criteria strings for searching records
Determining data type for search criteria
Using RecordsetClone to search form records
Setting form bookmark from recordset clone
Implementing search functionality in form controls
Attaching the navigator class in the form's module
Using Nav.Find in control AfterUpdate events
Reusing the class module on multiple forms
Adding search boxes for different field types
Integrating an enum for search data types within the class
5. What's Next (6:50)
Microsoft Access Recordset Clone Search Navigation and Reusable Class Modules Review
Course wrap-up for Recordset Clone and preview of an orphan code detector utility.
