Code Library - No Longer Set

ListFields() Part 1: Listing Table Fields in the Immediate Window

An 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.

WizHook

Sorting Arrays of Strings in Access with WizHook

No need to write your own array-sorting code from scratch. Use the SortStringArray method of Access's hidden WizHook object instead!

WizHook

WizMsg(): A Simple Way to Create a MsgBox with Bold Text

Bold text in a Microsoft Access message box? It's true. And it requires no API calls, no third-party libraries, and no arcane string syntax. Check out WizMsgBox!

WizHook

Wiz(): Never Forget to Set the WizHook Magic Key

This convenience function handles setting the WizHook Key property with the required magic value once per session.

TempVars

GenerateTVClass(): Auto-Create a TempVars Class Module

The culmination of my TempVars series, this article shows you how to generate a TempVars class module from a local table.

Code Library

Create a Class Module from a String in Microsoft Access

Generate VBA class modules from strings during design time using this simple function in Microsoft Access.

Code Library

Writing Boilerplate Code by Hand is for Suckers

Writing 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.

Code Library

WriteTempFile(): A Simple VBA Function to Save Text to a New Temporary File

If you need to save a string to a temporary file in VBA, this simple function will do the trick.

Code Library

SetPredeclaredId(): Change the Hidden PredeclaredId Attribute of a VBA Class Module

This simple function overcomes the lack of a hidden attribute editor for PredeclaredId values in the VBA development environment.

Code Library

A GUID-Based Temporary File Name Generator

If you need a reliable and fast way to create lots of temporary file paths, a GUID-based filename generator has some compelling benefits.

Code Library

Getting the Temp Folder in VBA

There are many ways to get the temporary folder in VBA. But if you look behind the curtain, there's really only one...

TempVars

tblTempVar: Creating and Populating a Table of TempVars

These three simple procedures: (1) create, (2) populate, and (3) create/delete + populate a local table with the contents of the TempVars collection.

TempVars

Populating a List Box with the TempVars Collection

If you use TempVars in your Microsoft Access applications, this handy function will bring visibility to the contents of that collection.

Video

VIDEO: "Codifying" Long Names

Former Access MVP Jack Stockton translates my SQL Server "Codify()" function to work with Microsoft Access backend databases.

Code Library

ObscureInfo(): Hide Sensitive Information in Access Form Controls

Avoid over-the-shoulder attacks and prevent accidental disclosures in your Microsoft Access forms with this easy-to-implement function.

Code Library

NewSort(): Sort a Continuous Form by Clicking on the Column Label

Sort a continuous form in MS Access by simply pointing at a column label. These functions make it easy.

Code Library

UseHand(): Changing the Mouse Cursor in Microsoft Access

A classic Microsoft Access mouse cursor trick gets simplified and updated for 64-bit VBA compatibility.

Form Design

Triple-State Modern On/Off Switch in Access

Yes, No, or I Don't Know (or Don't Care). With this updated design, you can offer your users a third option with your modern on/off switches.

Code Library

3 Ways to Create Missing Subfolders in VBA

If you need to generate multiple levels of subfolders using VBA, these three functions will each get the job done.

Code Library

EnsurePathExists: A Unicode-Safe Way to Create Missing Subfolders in VBA

The EnsurePathExists function--based on the API function SHCreateDirectoryExW--is the ultimate tool for verifying and creating folder structures.

Code Library

MakeSurePathExists: Using the Windows API to Create Missing Subfolders in VBA

A Windows API function makes verifying (and creating, if necessary) a full folder hierarchy dead simple.

Code Library

LimitTextLength: Enforce Max Text Length for Unbound Text Boxes and Combo Boxes

A handy function to enforce maximum string lengths for unbound text boxes and combo boxes in Microsoft Access.

Code Library

GetTempPath: Using the Windows API for Maximum Performance

If you are looking to maximize performance in VBA, using the Windows API will almost always be your best bet.

Code Library

CreateGuid: A Reliable Way to Generate GUIDs in VBA

A well-tested method to generate GUIDs in both 32-bit and 64-bit VBA.

Hidden Features

AccHitTest: Returns the Form Control the Mouse Clicked On

This undocumented form function can help you write a generic click event for label controls.