How To Create Configurable System Settings Using GetSetting And PutSetting In Microsoft Access

In this video, you will learn how to create configurable system settings for your Microsoft Access database using a simple system settings table. I will show you how to set up a table to store name-value pairs, use DLookup to retrieve settings, and then make the process easier by building custom GetSetting and PutSetting functions for managing application defaults, toggling features, and handling scenarios like temporarily disabling order entry during inventory. This video is aimed at developer-level users and covers essential VBA topics and best practices for making your Access databases more flexible and maintainable. Graham from Fort Worth, Texas (a Platinum Member) asks: I want parts of my database to be configurable without having to change VBA code and push out an update every time. For example, I want to be able to change default values, toggle certain features on or off, or temporarily disable part of the system. When we do inventory on Sunday afternoons, I want to disable the order entry system so no one can place an order, and instead they get a message saying the order entry system is down during inventory. What's the easiest way to store and retrieve system-wide settings like this in Microsoft Access? BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: App Settings: https://599cd.com/AppSettings PREREQUISITES: System Defaults: https://599cd.com/SystemDefaults Intro to VBA: https://599cd.com/IntroVBA Variables: https://599cd.com/Variables Trim Function: https://599cd.com/Trim DLookup: https://599cd.com/DLookup NZ Function: https://599cd.com/NZ Double Double Quotes: https://599cd.com/DoubleDouble Type Conversion: https://599cd.com/TypeConversion Recordsets: https://599cd.com/Recordset Error Handling: https://599cd.com/ErrorHandling SQL with Access: https://599cd.com/SQLwithAccess Create Function: https://599cd.com/CreateFunction ByRef v ByVal: https://599cd.com/ByRef Variant: https://599cd.com/Variant Before Update: https://599cd.com/BeforeUpdate UP NEXT: App Settings, Part 2: https://599cd.com/AppSettings2 RECOMMENDED COURSES: Access Developer Courses: https://599cd.com/Developer FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates DIAMOND SPONSORS: More info on our Sponsors: https://599cd.com/DiamondSponsors ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 How to Use Access in 30 Minutes: https://599cd.com/30Minutes $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Merch Store! Get your swag here: https://599cd.com/Merch Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS: TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, app settings, GetSetting, PutSetting, configurable system settings, system settings table, DLookup, system defaults table, type conversion functions, CStr, CLng, CCur, CDate, Recordset, Nz function, error handling, SQL, ByVal, BeforeUpdate event, global module, design view QUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.