TempVars - No Longer Set

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.

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

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

Calling TempVars directly from a query can cause issues. Instead, use this simple wrapper function to save yourself some potential headaches.

Many Access users rave about using TempVars with queries. I decided to see what the hype was about. What I found shocked me.

A TempVars class module that provides visibility, type safety, IntelliSense, and compile-time typo checks.

The TempVars object is an intriguing alternative to traditional global variables, but it has some shortcomings. Here's one way to work around them.