0. Welcome (4:08)
How To Use Record Set Clone for Batch Processing and Reusable Search Functions in Microsoft Access
What is a Record Set Clone and how it works
Comparing Record Set Clone to Find Record
Using Find Next, Find First, No Match, and Bookmark
Building cleaner search routines with Record Set Clone
Looping through filtered records using Record Set Clone
Counting only visible (filtered) records
Batch updating filtered records
Respecting form filters in VBA code
Creating reusable Record Set Clone search functions
Finding records by ID, text, or date
Differences between Bookmark navigation and where conditions
Building navigation routines with Record Set Clone
1. RecordsetClone 1 (22:07)
Background Form Searching with RecordsetClone and Bookmark Navigation
Introduction to recordset clones in Access forms
How recordset clones work behind the scenes
Differences between FindRecord and recordset clone search
Using FindFirst to locate a record in a clone
Checking for matches using NoMatch
Using the Bookmark property to sync form and clone
Opening a form and navigating to a specific record
Advantages of using recordset clone over user interface navigation
Building a search box on a form using recordset clone
Handling search values and escaping quotes
Building multi-field search criteria with Like wildcards
Using FindNext to search for additional matches
Implementing FindFirst and FindNext in button events
Looping through matching records with recordset clone
Clearing up confusion about NoMatch logic
Professional search routines without UI flicker
Synchronizing the form to a record found in the clone
2. RecordsetClone 5 (22:45)
Loop Through Filtered Records and Batch Update Data with RecordsetClone
Using RecordsetClone to loop through filtered records
Counting visible records with RecordsetClone
Updating multiple records in bulk via RecordsetClone
Detecting empty recordsets using EOF and BOF
Moving to last record to get accurate RecordCount
Filtering form data and processing only visible records
Batch updating records based on user-applied filters
Building prompts to confirm bulk record actions
Using custom AreYouSure confirmation function
Selective updating to avoid unnecessary changes
Requerying forms after batch updates
Parameterizing batch updates based on a checkbox
Cleaning up recordsets after processing
Initial variable declaration and initialization for counters
Ensuring current edits are saved before looping (Me.Dirty = False)
3. RecordsetClone 5 (29:15)
Build Smarter Record Search Utilities for Multiple Data Types
Difference between RecordSetClone and opening tables/queries
Creating a reusable GoToRecordByID function
Passing form and field names as parameters
Checking if a form is open with IsLoaded
Using RecordSetClone to find records visible in form
Building dynamic criteria strings for FindFirst
Setting form bookmarks to the found record
Refactoring code to handle null and invalid values
Updating existing methods to use the new function
Testing GoToRecordByID with different forms and data
Filtering and updating list boxes on a form
Using double-click events to open forms and go to records
Expanding the function to handle text and date fields
Formatting dates for criteria in FindFirst
Escaping double quotes in text criteria
Adapting the function for all data types (number, text, date)
Handling data type mismatch issues in search criteria
Comparing bookmark search vs. WHERE filter for forms
4. What's Next (1:47)
How To Search Records and Use Recordset Clone with Bookmarks and Batch Updates in Microsoft Access
Using a recordset clone to search records
Navigating forms with bookmarks
Processing filtered recordsets
Performing batch updates in VBA
Building reusable VBA utilities for databases
