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