Posted in Technology

Show MS Access Subreports With No Data

On MS Access applications, usually I use subreport objects with SQL queries of their own, linked to the main report which includes the subreport. Classic example of such master-detail reports is invoices …

Posted in Technology

MS Access Reports: Sums from distinct group headers

The problem: When we use formulas on text boxes in the report footers of MS Access reports, such as “=sum(a_field_in_header)”, we get incorrect results because of duplication of same amounts for multiple items in detail section.

Posted in Technology

Faster lookup using VBA Collections

Problem: Reading records from the database and instead of using DLookup or querying the database all the time, to improve performance we can read them into a VBA collection object and refer to it in memory.

Posted in Technology

Update Query on MS Access

Microsoft programmers are always very particular on their way of approaching problems. Since they are the “biggest” software developers in the world, they have to set the standards!?