0. Welcome (5:07)
How To Build a Complete Dark Mode and Light Mode Theme System for Forms in Microsoft Access
Building a settings table for dark mode colors
Storing color palettes for forms, sections, and controls
Using hex colors instead of RGB values
Generating a list of all forms with array lists
Efficient management of forms using array lists
Capturing and saving form appearance properties
Looping through form sections and controls for properties
Storing color properties in a database table
Setting up reusable functions for theme management
Organizing and cleaning up VBA code structure
Switching between light mode and dark mode instantly
Applying saved theme settings to open forms
Ensuring new forms follow the current theme
Creating a themed background layer behind forms
Managing Access workspace appearance in dark mode
Controlling background layer behavior with theme settings
Adding event handler shortcuts for theming
Restoring button gradients in themed forms
1. Dark Mode 1 (22:01)
Build Dark Mode Settings Table And Learn ArrayList For Sorted Form Combo
Creating a dark mode system in Microsoft Access
Setting up a table to store color settings
Defining table fields for forms, sections, and controls
Using hex colors for background and foreground properties
Handling section numbers and control names in the table
Parsing form sections and controls to automate data entry
Creating a form to manage dark mode settings
Adding a combo box to list all forms in the database
Populating a combo box with form names using code
Using CurrentProject.AllForms to access all forms
Introducing and using ArrayList objects in VBA
Populating and sorting an ArrayList with form names
Filling a combo box with a sorted list from an ArrayList
Setting combo box properties: Limit to List and disabling edits
Creating a button to open selected forms in design view
Adding input validation for combo box form selection
2. Dark Mode 6 (25:15)
Build Save Form Mode Routine With Section And Control Attribute Capture
Creating a global save form mode routine
Passing form names and mode type to functions
Implementing a reusable check for form combo selection
Adding 'Are You Sure?' confirmation prompts
Consolidating duplicated button click event code
Organizing code into global modules for reuse
Deleting old color records before saving new ones
Ensuring forms are open in design mode for property reading
Looping through form sections to capture section color
Looping through controls to capture foreground and background colors
Optional parameters to distinguish controls from sections
Implementing RGB to hex color conversion for storage
Handling errors when controls lack color properties
Using recordsets to save attributes into a table
Conditional logic for whether object is a section or control
Saving section and control color values to a table
Debugging and compiling to ensure error-free code
Testing save routines for both light mode and dark mode
3. Dark Mode 6 (18:30)
Apply Dark Mode To All Open Forms by Loading Settings From Table
Saving and reading Light and Dark Mode settings
Adding Light Mode and Dark Mode toggle buttons
Using a global module for theme switching code
Looping through all open forms to apply a theme
Persisting the current mode at the system level
Applying theme changes instantly to open forms
Coding theme initialization for new form openings
Building the do_dark_mode subroutine for forms
Looping through form sections and controls to set colors
Using recordsets to query stored theme settings
Applying color settings using hex to RGB conversion
Adding per-form code in the On Load event for switching themes
Checking for control and section existence before setting colors
Saving and testing dark and light mode changes per form
4. Dark Mode 6 (17:58)
Make Access Application Window Appear Dark Behind All Open Forms
Setting the Access background to a custom color for dark mode
Creating a borderless background form in Access
Configuring form properties for a background form
Moving and resizing a form using DoCmd.MoveSize
Sending a form to the back using focus and the Z order
Using the Activate event to keep a background form in the back
Toggling the background form based on dark mode status
Opening and closing forms programmatically based on settings
Implementing the IsLoaded VBA function to check open forms
Adjusting command button gradients to restore effects
Using TypeOf to identify command buttons in VBA
Setting button gradient property for different modes
Updating dark mode routines to include the background form
5. What's Next (8:15)
Upcoming Features After Building Dark Mode Systems for Forms in Microsoft Access
This is a closing summary and preview message for an Access Developer video tutorial, recapping what was covered and teasing upcoming features.
