Tagged

Code Library

A collection of 155 posts

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.

Form Design

Modern On/Off Button in Access

Leave those boring checkboxes behind and move into the 21st century with these modern on-off switches for Microsoft Access. Very little code required!

Code Library

IMPROVED: SelectedListBoxItems() Function

A clearer and (very slightly) more performant version of my SelectedListBoxItems function.

Code Library

SelectedListBoxItems() Function

It's not difficult to get the selected items from a multi-select list box, but it is tedious. This function makes it simple and easy.

Code Library

3 Ways to Get and Set the TitleBar Text for an MS Access Application

Here are three ways to set the Application Title for an MS Access application. My preferred method allows getting and setting with a single line of code.

Code Library

clsApp: My Application-Wide MS Access Singleton Class Module

I use many class modules in my applications, but this is the one I cannot live without.

Code Library

LogToTempFile() Function

A quick and dirty method for debugging large strings in VBA.

Code Library

Set Report Properties in Bulk

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

Code Library

GetAttr(): Ribbon XML String-Building Helper Function

When you're building strings in code with lots of optional values--such as ribbon XML attributes--this simple function helps keep your code readable.

Code Library

XmlWrap() Function

This convenience function helps you write more readable code when building Office Ribbon-flavored XML strings.

Code Library

TagWrap() Function

This convenience function helps you write more readable code when building strings with HTML-style opening and closing tags.

Code Library

SQL Server "Codify" Function

This function will jump-start the process of converting long descriptions into meaningful abbreviations. It's great for creating "Code" columns in lookup tables.

Code Library

Show a Friendly Message When a Report Has No Data

A handy function you can call from an Access report's Property Sheet to gracefully inform the user when their report has no data to display.

Code Library

Printf Function

User @wqweto's string interpolation VBA function has some neat tricks, like using Unicode's Private Use Area to get safe temporary placeholder characters.

Code Library

Displaying Very Long Human Readable Time Spans

With 29-million-year time spans, you can handle almost any task (besides evolution, continental drift, and adding the LAA flag to MS Access).

Code Library

Displaying Human Readable Time Spans

The HumanizedSeconds() and ConvertToSeconds() functions work hand-in-hand to provide a general solution for storage and display of time spans.

Code Library

The Pluralize Function

You don't have to settle for messages like, "1 record(s) inserted." This simple function is an easy way to format strings for pluralization in VBA.