0. Welcome (4:45)
How To Sync Dark Mode With Windows and Sort Data Using Bubble Sort and ADO in Microsoft Access
Improving Access dark mode background form with Windows API
Ensuring background form stays behind all windows
Resizing background form to fit Access window
Eliminating scroll bars on background form
Proper API declaration and usage in VBA
Timing API calls to send form to back
Converting window dimensions for proper sizing
Differences between Me.Move and DoCmd.MoveSize
Reading Windows dark mode setting from registry
Locating and reading registry key with VBA
Applying Access theme based on registry value
Synchronizing Access and Windows dark mode settings
Setting Windows theme from Access with VBA
Bubble sort algorithm explained in Access VBA
Demonstration and coding of bubble sort in VBA
Loading and sorting form names into an array
Using sorted array in Access combo box
Sorting data using temporary tables and DAO record sets
Creating and using disconnected in-memory ADO record sets
Eliminating temporary tables with in-memory ADO record sets
Best practices for sorting with SQL Server and Access
1. Dark Mode 5 (22:14)
How To Use Windows API For Background Form Position And Sizing In Microsoft Access Dark Mode
Using Windows API SetWindowPos to keep background form behind
Explanation of window handles (HWND) in Access forms
Public declaration of API and related constants in modules
Setting the background form Z-order with SetWindowPos
Timing and use of the Timer event for API calls
Difference between Me.Move and DoCmd.MoveSize
Resizing the background form to match the Access window
Using Windows API GetClientRect to get inner window size
Explanation and usage of RECT type in VBA
Converting pixel dimensions for Move/Resize operations
Handling timing quirks when sending forms to back
Limitations when resizing the main Access application window
Suggestions for workarounds to monitor window resizing
2. Dark Mode 6 (20:10)
Read Windows Dark Mode From Registry And Control System Theme From Access
Reading Windows Dark Mode setting from the registry
Using VBA to read registry keys in Access
Retrieving the AppsUseLightTheme registry value
Applying Access theme automatically at startup
Writing VBA code to check Windows dark mode status
Debugging and adjusting logic for light/dark mode detection
Handling potential errors when reading registry keys
Setting all forms to dark mode in Access
Using SaveKey to write to the Windows registry
Changing Windows system theme from Access
Creating buttons in Access to control Windows dark/light mode
Understanding registry key types (REG_DWORD)
Synchronizing Access theme with system dark mode settings
3. Bubble Sort (22:31)
How To Implement Bubble Sort in Microsoft Access VBA to Sort Arrays
Identifying .NET dependency issues in Access VBA
Explanation of COM interop and System.Collections.ArrayList
Risks of relying on external frameworks in production
Why .NET version compatibility matters for VBA solutions
Loading form names into a VBA array
Implementing bubble sort in VBA with nested loops
Step-by-step bubble sort logic and demonstration
Swapping array values using a temporary variable
Populating a combo box with a sorted array in VBA
Avoiding external dependencies when sorting in Access VBA
4. In-Memory Recordset (18:56)
DAO with Temp Tables & ADO Disconnected Recordsets for Sort Data in VBA
Creating and dropping temporary tables in Access using SQL
Loading form names into a temporary table with VBA
Sorting data in Access using SQL ORDER BY in a temp table
Populating a combo box from a sorted DAO recordset
Cleaning up by dropping temporary tables in VBA
Creating a disconnected in-memory ADO recordset
Appending fields to an in-memory ADO recordset
Populating an in-memory ADO recordset with form names
Sorting an in-memory ADO recordset by a field
Loading a combo box from a sorted ADO recordset
Using late binding to avoid reference conflicts in VBA
Advantages of in-memory recordsets over temp tables in Access
5. What's Next (3:55)
Reviewing Background Forms, Bubble Sort, ADO Recordsets. What's Coming Next?
This is a summary/wrap-up and preview message for a Microsoft Access Developer course session. It mentions techniques and topics covered in previous and upcoming classes but does not itself provide a tutorial or walkthrough.
