VBA Naming Conventions

VBA Naming Conventions

If you’ve ever opened a macro you wrote a year ago and stared blankly at a variable named x2, you already understand the problem this post solves. VBA doesn’t force you to name anything meaningfully — it’s perfectly happy with x, temp, and a...
Database Naming Conventions

Database Naming Conventions

Open an unfamiliar database and you can usually tell within thirty seconds whether the person who built it thought about naming. Tables called “Table1,” queries called “Query3,” and a report saved as “Copy of Copy of Report” are a...
Cutting Out and Lining Up the Herd

Cutting Out and Lining Up the Herd

Cutting a herd is only half the job. (As we covered in our last post, "cutting" a herd means separating out the matching cattle — not cutting and pasting them.) Once the matching cattle are cut from the larger group, a good trail boss doesn't leave them scattered — he...