Lessons

Lesson Summary

Lesson 1: Sync Office Theme via Registry & Profiles - In lesson one, we will walk through how to control the Microsoft Office theme from inside Access using both the Windows registry and roaming profile settings, ensuring Office applications like Access, Word, and Excel match your dark and light mode preferences. I will show you how to dynamically locate and update the correct registry keys for each user's Microsoft profile, broadcast theme changes across Windows components, and automatically restart Access to apply changes. We will discuss how theme settings sync across devices and how to find your own Office theme values. Next lesson, we will integrate the VB editor for full dark mode support.

Lesson 2: VBA Editor Themes in Dark Mode - In lesson two, we continue by bringing the VBA editor into our dark mode system, making its theme settings switch automatically using values stored in the registry. I will show you how to handle multiple monitors so all taskbars update correctly, discuss the quirks of getting external apps like Office programs to respond, and demonstrate how to read and write VBA editor color settings from and to the registry using a settings table. We will also refine the interface and clean up button actions, ensuring dark mode changes apply smoothly across your Access environment.

Lesson 3: Subforms, Cmd Line, Win Color, Restart - In lesson 3, we will walk through completing the dark mode system by addressing subforms, adding command line control and shortcuts, setting the Windows desktop color based on mode, and refining the code for reusability. We will also discuss handling Access-only dark mode, demonstrate how to create desktop shortcuts to toggle modes with command line parameters, and explain how to find and adjust Office theme values in the Windows registry or with PowerShell. This lesson wraps up the dark mode system for now, unless further requests are made.

Keywords

access developer 57

Subscribe to Access Developer 57
Get notifications when this page is updated

Intro

In lesson 3, we will walk through completing the dark mode system by addressing subforms, adding command line control and shortcuts, setting the Windows desktop color based on mode, and refining the code for reusability. We will also discuss handling Access-only dark mode, demonstrate how to create desktop shortcuts to toggle modes with command line parameters, and explain how to find and adjust Office theme values in the Windows registry or with PowerShell. This lesson wraps up the dark mode system for now, unless further requests are made.