In this installment, we explore two different approaches for deciding when to invalidate our cache: user-triggered and automatic.

In this installment, we demonstrate how simple it is to refresh the cache when you use self-healing object variables.

In this installment, we reduce our database calls by more than 80% by shifting the bulk of the work to high-performing VBA dictionary structures.

In this installment, we use custom recordset-based VBA functions to implement multi-level group headers in an editable continuous form.

In this installment, we use the DCount() domain aggregate function to create an editable continuous form with hidden group header values.

In this installment, we use Bill Karwin's inequality LEFT JOIN technique to handle multi-column sorting without grinding everything to a halt.

In this installment, we use GROUP BY subqueries to generate a read-only record source for a continuous form that hides duplicate header values.

There are two primary ways to group records in an Access report: with AND WITHOUT group headers. ... Wait, what?!?!

This article contains the sample data for following along with the rest of the "Hiding Duplicate Values" series.