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.Mike WolfeNo Longer SetThe Dependency TrainLet’s torture a train metaphor to illustrate the dangers of dependency chaining.Mike WolfeNo Longer SetCreating Optional DependenciesUsing conditional compilation to avoid the “Dependency Train” problem.Mike WolfeNo Longer SetCode Library UpdatesQ: How do you manage updates to code library modules? A: Version control and backward compatibility zealotry.Mike WolfeNo Longer SetclsAppVBA 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.Mike WolfeNo Longer SetEnvironmentally Friendly AccessUsing the Windows Registry to manage Production, Development, and Testing environments in #VBA and #MSAccess.Mike WolfeNo Longer SetclsStatusDon’t Settle for the “Status” QuoWherein I wrap Access’s built-in status bar functions inside a class module for more readable code.Mike WolfeNo Longer SetString FunctionsQuoth thy SQL? Evermore!Solving the “O’Malley problem” with dedicated functions to sanitize our strings. Little Bobby Tables would be proud.Mike WolfeNo Longer SetCome TogetherDo you build strings in loops? Stop trimming the delimiter at the end of the loop. There’s a better way.Mike WolfeNo Longer SetPart 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.Mike WolfeNo Longer SetDesign 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.Mike WolfeNo Longer SetListing 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.Mike WolfeNo Longer SetForm 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.Mike WolfeNo Longer SetFilling 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.Mike WolfeNo Longer SetWhy so lazy, Access?Introducing FormIsOpen() and ReportIsOpen(), two simple functions to help deal with Access’s laziness.Mike WolfeNo Longer SetImage 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.