Code Library - No Longer Set (Page 6)

Unicode-Safe Filtered Filename Lookups

Need a Unicode-safe way to retrieve a list of filenames from a folder? And its subfolders? And filtered by filename? It's all here!

Code Library

Clearing a List Box in Access

Sometimes you need to wipe the slate clean and start fresh. Here's a simple function to do just that for an Access list box.

Advanced

"Complex" DTOs in VBA

Can you use the OpenArgs parameter to pass multiple values to forms and reports with compile-time checking? You can if you use DTOs.

Code Library

Writing Code with Code in VBA

Can you write code with code in VBA? Yes. Should you write code wit--OH, BE QUIET YOU!!! Where's your sense of adventure? ;-)

Code Library

Text Files: Read, Write, Append

There is beauty in simplicity. These three functions for reading, writing, and appending text files are simple, but effective.

Code Library

Kill Failed? Let User Try Again

My Access applications regularly need to overwrite existing files. A common example is exporting data to a text file, such as a .csv. Sometimes the user chooses to overwrite the existing file, and sometimes the program is hard-coded to save to a specific filename. Oftentimes, the user wants to immediately

Code Library

The Subtle Dangers of Dir()

If Len(Dir(FullPath)) > 0 Then 'the file exists. This potential bug patiently waits to pounce and ruin another poor programmer's day.

Advanced

Recursion Demystified: Creating Subfolders

Recursion: it's not just for calculating factorials any more! A practical example of using recursion to create multiple missing subfolders.

Code Library

Converting Numbers to Text

Need to print business checks directly from Microsoft Access? You'll need a way to convert numbers into text. The NumToString function does just that.

Code Library

KeepFormOnCanvas(): Get Back Here, Form!

What happens if the user resizes their Access window so that our form can't open in its entirety? KeepFormOnCanvas() to the rescue!

Code Library

Fun with Form Windows

Using my FillAccessWindow function to resize Form and Report objects relative to the amount of available space on the Access canvas.

Code Library

"Convenience" Date Functions

The DateSerial function is easy to write, but it's not as easy to read. Let's make our code easier to read with some "convenience functions."

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

Code Library

Listing External Table Sources

Using the Parse() function to list linked tables by source. Use this when you want to refer to Linked Table Manager info while writing code.

Code Library

Part and Parse()-l

Take the Tag property and OpenArgs argument to the next level. This function makes it easy to assign and extract multiple values from a single string.

Code Library

Don't Settle for the "Status" Quo

Wherein I wrap Access's built-in status bar functions inside a class module for more readable code.

Code Library

Environmentally Friendly Access

Using the Windows Registry to manage Production, Development, and Testing environments in #VBA and #MSAccess.

Code Library

Why so lazy, Access?

Introducing FormIsOpen() and ReportIsOpen(), two simple functions to help deal with Access's laziness.

Code Library

Filling in the Blanks

One of the keys to being a good developer is to make the *easy way* also be the *right way*. Exhibit A: the ControlIsBlank() function.

Code Library

My Dirty Little Secret

I don't use Me.Dirty = False in my #msaccess code. I wrap it up and call it from a "guard clause" instead.

Code Library

Code Library Updates

Q: How do you manage updates to code library modules? A: Version control and backward compatibility zealotry.

Intermediate

Cookie Cutter Forms

How do you reuse a form with external dependencies in multiple projects? Interfaces.

Intermediate

Backward-Compatible Refactoring

How can you completely change the way you interact with a class without breaking backward compatibility? Interfaces.

Code Library

Creating Optional Dependencies

Using conditional compilation to avoid the "Dependency Train" problem.

Code Library

The Dependency Train

Let's torture a train metaphor to illustrate the dangers of dependency chaining.