Create Configurable System Settings for Access Part 3

In part 3, we continue building the app settings feature in Microsoft Access by adding the ability to write user changes back to the settings table. I will show you how to create a reusable PutSetting subroutine that accepts different data types and safely writes the setting value using a recordset. We will discuss validating inputs, deleting and re-adding records, and how to trigger these updates from form events, allowing changes like main menu notes or default state settings to be stored in your database.

Members

In the extended cut, we will cover how to check if the settings table exists when the database loads and create it automatically if missing, work with system colors for defaults on form backgrounds, and make settings user specific so each user can have their own custom settings. I will show you how to implement these features step by step.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  File Download - Gold Members
• Members Only Discussion

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• App Settings, Part 2
• Notes Anywhere

Links

• RunSQL v Execute
• Happy Holidays Means Everyone
• Code Vault - System Settings

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, app settings, settings table, write value to table, DLOOKUP, manual SQL, function module, put value function, put setting function, ByVal, ByRef, data type Variant, recordset, error handling, delete value SQL, CurrentDb.Execute, OpenRecordset, AfterUpdate event, GetSetting, user specific settings, default state, system colors, code vault