Conventions - No Longer Set

PascalCase All the Things

There is only one correct capitalization convention in VBA: PascalCase.

Debug Documentation: Signal vs. Noise Edition

Debugging an issue can generate a lot of content. This technique helps you keep track of and find the parts that really matter.

Conventions

My File System Variable Naming Convention for VBA

"SourcePath" may be one of the worst variable names ever written. Is it the full path to a source file? Is it the folder where my source files are located?

Conventions

Naming Conventions Matter: Making Wrong Code Look Wrong

Joel Spolsky and Antonin Scalia join forces to help illustrate the importance of sensible code naming conventions.

Conventions

Database Date Field Naming Convention

Naming is hard. When it comes to naming conventions, the key is to keep things simple. Here's how I like to name the date and time fields in my databases.

Conventions

Beautiful Blocks of Boilerplate

Using the colon character to join multiple lines of code all willy-nilly can lead to messy code. But, used judiciously, it can create beauty from chaos.

Intermediate

Parameterized Constructors in VBA

VBA does not allow for parameterized constructors. We can work around that, though, using the Factory pattern and a strong naming convention.

Conventions

Googleable Field Names

Using globally unique field and table names will make it easier to identify where such fields and tables are used throughout your application.

Conventions

Comment Continuations

Using ellipses to "group" comments separated by intervening lines of code.

Conventions

Enum Type Naming Convention

The combination of "IntelliSense overload" and "global identifier case changes" convinced me I needed a different approach.

Conventions

VBA Squeeze Box

I discussed previously the differences between passing by value and passing by reference. I now want to discuss how and when I use each in my own code.