> ## Content Index > Fetch the complete content index at: https://nolongerset.com/llms.txt > Use this file to discover other available public pages before exploring further. # Archive Collection: Design Functions - URL: https://nolongerset.com/archive-design-functions/ - Published: 2024-01-08T18:55:00.000Z - Updated: 2026-05-08T12:37:57.000Z - Description: I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Design Functions. - Author: Mike Wolfe - Tags: Archive, #Import 2026-05-20 02:59 *I've been writing a daily article here since September 1, 2020; that's over 1,200 articles. I haven't missed a day yet, and that includes [Christmas and Easter](https://nolongerset.com/tag/holiday/). I'm currently on a family vacation, which makes maintaining this streak a bit...tricky.* *I'm writing this in the *present* tense, but I'm writing it for *future* publication with links to *past* articles. Let's hope the time-space continuum holds up.* *In any case, as the slacker Firstie says to the Stony Lonesome Gate guard twenty minutes before Taps, let me get to the Point. I've got a daily publishing streak to keep up. But I don't want to be writing and publishing articles on vacation. And I still want to provide you with something of value to read each day. So I settled on creating a series of curated article lists that I think you'll find beneficial.* *I'm hoping at least some of these articles are ones you haven't read before. And if you're so obsessed with me that you *have* read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.* *Enjoy!* --- ## Design Functions These articles cover various routines that are meant to be used by the developer at design time to speed up (or otherwise improve) the development process. [Python-inspired Doc Tests in VBADoc tests are not a replacement for unit or integration testing. But they do provide the best return on investment (ROI) of any type of test, mostly because the effort to write them is near zero.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/09/20200921_173427---gbm18---.png)](https://nolongerset.com/python-inspired-doc-tests-in-vba/) [Poor Man’s Status Bar in VBAIf you’re looking for a quick and dirty way to keep track of a long-running process while developing, this VBA one-liner will do the trick.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/07/Poor-Man-s-Status-Bar.jpg)](https://nolongerset.com/poor-mans-status-bar/) [How to Set a Breakpoint Inside of an Access QueryDid you ever want to set a breakpoint inside of an executing query? How about inside a form event property? This trick lets you do it.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/03/black-and-white-1282260_1920.jpg)](https://nolongerset.com/watch-this/) [Listing 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.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/bistro-498504_1920.jpg)](https://nolongerset.com/listing-external-table-sources/) [ListFields() Part 1: Listing Table Fields in the Immediate WindowAn easy way to reduce context switching between the VBA IDE and the Access application window is to list table field names in the immediate window.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/12/ListFields-Part1.png)](https://nolongerset.com/listfields-part1/) [Converting VBA Long Color Values to RGBThe VBA RGB() function converts red, green, and blue values into a VBA long integer color value. This simple function works in the other direction.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/12/Designer.png)](https://nolongerset.com/convertcolortorgb/) [LogToTempFile() FunctionA quick and dirty method for debugging large strings in VBA.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/07/writer-1421099_1920.jpg)](https://nolongerset.com/logtotempfile-function/) [Set Report Properties in BulkLooking to set a report property, such as an event handler, to the same value for multiple reports? Use this routine to automate the whole process.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/06/store-5619201_1920.jpg)](https://nolongerset.com/setreportproperties/) ### Generating Code Writing boilerplate code is tedious, prone to silly mistakes, and difficult to maintain if you have to change the underlying logic. It's also a [necessary evil in VBA](https://nolongerset.com/boilerplate-code-problems/). One way to avoid these downsides–especially the last one–is to automate the generation of the boilerplate code. This section includes articles that will help you automate the generation of boilerplate VBA code. The first and third articles are my personal favorites. For additional related articles, check out the [CodeGeneration Routines section](https://nolongerset.com/code-library/#hash-codegeneration) of my Code Library. [Strongly-Typed Collections: The Easy WayCreating a strongly-typed collection class in VBA requires jumping through code export-import hoops. What if you didn’t have to, though?![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/03/shelby-3821715_1920.jpg)](https://nolongerset.com/strongly-typed-collection-classes-the-easy-way/) [SetPredeclaredId(): Change the Hidden PredeclaredId Attribute of a VBA Class ModuleThis simple function overcomes the lack of a hidden attribute editor for PredeclaredId values in the VBA development environment.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/10/SetPredeclaredId-1-.jpg)](https://nolongerset.com/setpredeclaredid/) [VBA Code Generation TrickUsing Notepad++ to transform existing code into a VBA string that generates itself.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/12/Generating-VBA-Strings-with-Notepad---Macros.jpg)](https://nolongerset.com/vba-code-generation-trick/) [Writing Code with Code in VBACan you write code with code in VBA? Yes. Should you write code wit--OH, BE QUIET YOU!!! Where’s your sense of adventure? ;-)![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/12/combat-diver-60545_1920.jpg)](https://nolongerset.com/writing-code-with-code-in-vba/) [Writing Boilerplate Code by Hand is for SuckersWriting repetitive code may be a necessary evil in VBA, but it’s a lot less tedious if you generate most of it in VBA itself.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/10/farmer-walks-2141197_1920.jpg)](https://nolongerset.com/upsertstandardmodule/) [Create a Class Module from a String in Microsoft AccessGenerate VBA class modules from strings during design time using this simple function in Microsoft Access.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/10/portrait-5544201_1920.jpg)](https://nolongerset.com/upsertclassmodule/) [GenerateTVClass(): Auto-Create a TempVars Class ModuleThe culmination of my TempVars series, this article shows you how to generate a TempVars class module from a local table.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/10/elephant-964898_1920.jpg)](https://nolongerset.com/generatetvclass/) ### Additional Reading [Code LibraryBuilding Your LibraryThirteen years ago, I chose to maintain a folder of textfiles rather than a single Access database library. I’ve never once regrettedthat decision.No Longer SetMike Wolfe \[https://nolongerset.com/building-your-library/\]TheDependency TrainLet’s torture a train metaphor to illu…![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/09/prague-980732_1920.jpg)](https://nolongerset.com/code-library/#hash-designprocedures)