"Life is really simple, but men insist on making it complicated." ~Confucius
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. … Continue readingMS Access Reports: Sums from distinct group headers
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. … Continue readingFaster lookup using VBA Collections
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!? … Continue readingUpdate Query on MS Access