Code Library - No Longer Set

Events

The ArrowKeyNav Routine

Enable Excel-like navigation in your continuous forms by overriding the default behavior of the up and down arrow keys.

Code Library

Getting a Temporary File Name with VBA

Here is a simple function to generate an unused temporary file name in VBA.

Code Library

Finding the Temporary Folder with VBA

Be a good steward of your users' file system. If you are creating temporary files, be sure to create them in the designated temporary folder.

Code Library

Nothing To See Here

Introducing InformNoData(), a simple function to improve the user experience when there is no report data to show.

Reports

PreviewReport Function

This custom function is the simplest and safest way to preview reports in any Microsoft Access application.

Code Library

Watch This!

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

Code Library

Looping by Month: Loop Until with DateAdd

Reader Francesco Foti writes in with his own solution to the Looping by Month challenge.

Code Library

Looping by Month: Lookup Table

Have I ever used this method? No. Can I imagine a situation where it could be useful? Maybe. Should I write an article about it? Sure, why not.

Code Library

Creating a Monthly Lookup Table

Having a table where each record represents a single month can come in quite handy. Let's create such a table.

Code Library

Looping by Month: Custom Functions

By using a couple of custom functions, we can write very readable loops that iterate one month at a time.

Code Library

Looping by Month: DateSerial

The first approach to looping by month uses only the builtin VBA functions DateSerial() and DateDiff().

Code Library

Sticky Wicket: Looping by Month

Some programming problems are difficult to solve. Others are difficult to solve clearly.

Code Library

RegOp Quick Tip

Be respectful of your user's registry. Store all your applications' settings in a dedicated publisher subkey.

Code Library

RegOp Class for 64-bit VBA

Updating a classic VBA registry reading and writing class module for 64-bit compatibility.

Code Library

Joining Paths in VBA

How many times have you gotten a runtime error because you had duplicate or missing backslashes in your file paths? Never again!

Code Library

Using TDD to Calculate Holidays in VBA

This article takes you step-by-step through the Test Driven Design process, unencumbered by the complexity of any sort of testing framework.

Code Library

Counting Business Days in VBA

Counting business days is easy with the WeekDayCount() and FedHolidays() functions. What's interesting is how we test the WorkingDayCount() function.

Code Library

Counting Weekdays in VBA

This otherwise mundane function is made a bit more interesting through its use of the little-known VBA backslash operator, which performs integer division.

Code Library

IsLastBusinessDayOfMonth() Function

I bet you can't guess what this function does.

Code Library

VBA IsBusinessDay() Function

A simple function that returns True except for weekends and US federal holidays.

Code Library

Federal Holidays in VBA

How do you calculate US federal holiday observances in VBA? One option is to use brute force and skip the calculation altogether.

Basic

The Global Form

Storing global variables on a hidden form has some distinct advantages over storing them in VBA.

Code Library

Setting MultiSelect At Runtime

You can't actually set a list box's MultiSelect property at runtime. But there are a few ways to work around the limitation. Let's explore them.

Code Library

Get a Handle on Window State

Using the IsZoomed and IsIconic API calls to return the window state (minimized, maximized, or restored) of a form, report, or Access itself.

Basic

Unicode-Friendly MsgBox

There's a great big world outside of the ANSI bubble. Make every MsgBox in your program Unicode-safe in no time at all with this drop-in replacement.