Tag: Access

Show MS Access Subreports With No Data

On MS Access applications, usually I use subreport objects with SQL queries of their own,…

MS Access Reports: Sums from distinct group headers

The problem: When we use formulas on textboxes in the report footers of MS Access…

Faster lookup using VBA Collections

Problem: Reading records from the database and instead of using DLookup or querying the database…

Update Query on MS Access

Microsoft programmers are always very particular on their way of approaching problems. Since they are…