Convenience Functions - No Longer Set

FirstValidPath()

Simplify your VBA code with the versatile FirstValidPath convenience function, which efficiently determines the first valid path from a list of potential matches.

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.

Convenience Functions

Convenience Functions (My Secret Weapon to Create Self-Commenting Code)

How much can you really gain by replacing one line of code with a different, functionally equivalent line of code? Quite a bit, as it turns out.

Convenience Functions

The TrySetFocus Convenience Function

The TrySetFocus function attempts to set focus to a control. If the operation succeeds, it returns True; otherwise, it returns False.

Convenience Functions

Avoiding the Error "invalid reference to the property CurrentRecord"

Error number 2455, "You entered an expression that has an invalid reference to the property CurrentRecord," is annoying, but there is an easy fix.

Code Library

Now you have two problems

Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems. --Jamie Zawinski