by Jonathan Halder | Aug 6, 2025 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding
I had another Access report challenge. In my previous workaround using a Subreport in the main Report Footer section, I was able to hide the page header on the final page. Unfortunately, this is where my Page x of y field was located which was also hidden. In this...
by Jonathan Halder | Jul 17, 2025 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding
I had a customer with an Access database who wanted me to tack a page with completely different info and format to the last page of a main report. This main report would run in an automated fashion and is emailed to a list of users and it is also able to be run...
by Jonathan Halder | Jun 20, 2025 | Blogging, MS Access, MS Access Queries, MS Access Reports, MS Access VBA Coding
I was asked by a customer to mark fields in red that changed each week in a report. So what strategy did I come up with? Well first I need to store the data from the original run of the report. The customer wants to know what changed since the last automated report...
by Jonathan Halder | May 5, 2025 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding
I was using a quick technique today to hide certain fields on a report detail section that were repeating. There is a very quick solution to this in which you can use the “Hide Duplicates” property in the Format properties of a text box let’s say....
by Jonathan Halder | Apr 2, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding, Versioning
In today’s adventure, I have a complex application I am updating from an older version of our Access Jump Start application template from when we were calling it RDF (Rapid Development Framework). I am doing this so I will have access to some of the newer...
by Jonathan Halder | Mar 27, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
Did you know that you can drag and drop items from the navigation pane in one Access database to another Access database? I used this feature today as I needed to copy a somewhat complex form to display a series of entries in a linked table in both databases filtered...
