Code Library Building Your LibraryThirteen years ago, I chose to maintain a folder of text files rather than a single Access database library. I’ve never once regretted that decision.No Longer SetMike WolfeThe Dependency TrainLet’s torture a train metaphor to illustrate the dangers of dependency chaining.No Longer SetMike WolfeCreating Optional DependenciesUsing conditional compilation to avoid the “Dependency Train” problem.No Longer SetMike WolfeCode Library UpdatesQ: How do you manage updates to code library modules?A: Version control and backward compatibility zealotry.No Longer SetMike WolfeclsAppVBA Alchemy: Turning Methods Into PropertiesOne can check the status of screen painting in Excel, but not in Access. This turns out to be an important shortcoming. Let’s remedy it.No Longer SetMike WolfeEnvironmentally Friendly AccessUsing the Windows Registry to manage Production, Development, and Testing environments in #VBA and #MSAccess.No Longer SetMike WolfeclsStatusDon’t Settle for the “Status” QuoWherein I wrap Access’s built-in status bar functions inside a class module for more readable code.No Longer SetMike WolfeString FunctionsQuoth thy SQL? Evermore!Solving the “O’Malley problem” with dedicated functions to sanitize our strings. Little Bobby Tables would be proud.No Longer SetMike WolfeCome TogetherDo you build strings in loops? Stop trimming the delimiter at the end of the loop. There’s a better way.No Longer SetMike WolfePart and Parse()-lTake the Tag property and OpenArgs argument to the next level. This function makes it easy to assign and extract multiple values from a single string.No Longer SetMike WolfeDesign ProceduresOne Thing at a (Hundred) TimesHow to use Run() and GetTickCount() for some quick and dirty performance profiling. Come for the code, stay for the scolding on premature optimization.No Longer SetMike WolfeListing External Table SourcesUsing the Parse() function to list linked tables by source. Use this when you want to refer to Linked Table Manager info while writing code.No Longer SetMike WolfeForm FunctionsMy Dirty Little SecretI don’t use Me.Dirty = False in my #msaccess code. I wrap it up and call it from a “guard clause” instead.No Longer SetMike WolfeFilling in the BlanksOne of the keys to being a good developer is to make the *easy way* also be the *right way*. Exhibit A: the ControlIsBlank() function.No Longer SetMike WolfeWhy so lazy, Access?Introducing FormIsOpen() and ReportIsOpen(), two simple functions to help deal with Access’s laziness.No Longer SetMike WolfeImage by izoca from Pixabay of the beautiful Klemintinum library in Prague. If you ever visit, remember the rules: "No talking, no running, and absolutely no defenestrating." It's been an issue.