Basic - No Longer Set

Why Creating Multiple Copies of a Form Is Bad Practice

Creating multiple *instances* of a single form may seem like more work than just making multiple *copies* of a form, but it's an investment worth making.

Basic

Should you install 32-bit or 64-bit Access in 2023?

Which version of Access (and/or Office) should you install: 32-bit or 64-bit? We go way deep into the differences and similarities between the two options.

Basic

Why You Should Always Use Option Explicit in VBA

Don't let typos and logic errors ruin your VBA code. Read our latest blog post to learn about the importance of Option Explicit and how to use it.

Subs vs. Functions

Subs vs. Functions in VBA

What is the difference between a Sub and a Function and why would you use one or the other? I'll give you the short answer...and then we can explore the long answer.

VBA

Enums in VBA: A Great 10-Minute Introductory Video

Excel MVP Paul Kelly packs a bunch of great information (including a well-hidden feature) into this ten-minute video introducing Enums in VBA.

Basic

All About Indenting

Do you obsess over the smallest details of the code-writing process? If not, you might want to skip this article. Don't say I didn't warn you...

Basic

The Single Most Important Concept for Understanding Relational Databases

If you're coming to the database world from the spreadsheet world, this one key concept will help you make the necessary mindset shift.

Commentary

How to Know When to Turn Lines of Code Into a Standalone Routine in VBA

DRY vs. YAGNI. Don't Repeat Yourself or You Ain't Gonna Need It? Sometimes it's not obvious whether a block of code would be useful as a standalone routine.

SQL

SQL Gotcha: When an OUTER JOIN Accidentally Becomes an INNER JOIN

If you apply a WHERE filter directly to the OUTER JOIN side of a query you will effectively turn it into an INNER JOIN.

Basic

Learn VBA From a Master

Philipp Stiefel is on a very short list of people who I would pay to teach my employees how to write VBA.

Basic

The Strange Behavior of Null

When are two identical values not equal? When they're both Null! If you are a Microsoft Access developer, you need to understand how (and why) this works.

SQL

Fixing Circular References in Access Queries

Did you get the error message, "Circular reference caused by alias 'MyField' in query definition's SELECT list"? Don't worry; it's an easy fix!

Basic

Microsoft Access Acronyms

Bookmark this handy reference so the next time you come across an Access acronym that you don't recognize, you will have a quick way to look it up.

Basic

How to Pause VBA Code

A simple Windows API call makes for a reliable and efficient way to pause your VBA code. Much better than a "do-nothing loop."

SQL

When to Use Right Outer Joins in SQL

What's the difference between a RIGHT JOIN and a LEFT JOIN and why use one versus the other?

Basic

How to Loop Through a List of Strings in VBA

Looking for a quick and simple way to loop through a list of strings? These 4 lines of code are all you need.

SQL Server

3 Gotchas of the SQL BETWEEN Statement

The SQL BETWEEN statement produces very readable condition expressions. But developers of all skill levels can still get into trouble with it.

Debugging

How to Set a Breakpoint in Startup Code in VBA

Ever set a breakpoint in your Access application's startup code, only to have it get cleared before it got hit? There's a simple workaround.

Basic

The QBE Window: Training Wheels for Access Developers

If you're new to relational databases, the QBE window is the solution to--and cause of--many of your query problems.

Basic

Beware the BETWEEN

Using the BETWEEN clause with date-time fields may lead to unexpected results. There's a safer alternative.

Basic

The Difference Between Good and Bad Code Comments

The difference between good and bad comments explained in under 25 words.

Basic

How to Customize the Access Ribbon on a Developer Machine

This step-by-step guide shows you how to customize the Microsoft Access ribbon and add missing commands.

Basic

What the Vancouver Stock Exchange Can Teach Us About Rounding Numbers in VBA

So you think you know how to round decimals. Do you, though? There may be more to it than you think.

Basic

How to Pause Your VBA Code For a Set Amount of Time

There is no built-in function to pause code in VBA. The easiest and safest way to do it is to use the Sleep API function. Here's a quick how-to.

Basic

Avoid DoCmd.RunSQL in Microsoft Access

If you are just starting out writing VBA in Microsoft Access, you may be tempted to use DoCmd.RunSQL. Don't. There is a better way.