by Jonathan Halder | Aug 7, 2025 | Blogging, MS Access, MS Access Queries, MS Access Tables
I have a table that that stores info for a filename in each record, and another table that stores multiple rows for each file record representing the data. I wanted to update the file table with the maximum and minimum dates found in each record so I crafted a query...
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 | Aug 5, 2025 | Blogging, MS Access
Every day I remind myself that I am working to help businesses simplify and provide software to streamline people’s work. I use that phrasing to keep my focus on why I am using my Access skills. I want to bring simplicity. I try to use these aspects in my work...
by Jonathan Halder | Aug 4, 2025 | Blogging, MS Access, Versioning
Versioning systems are great for me as a business entity. It gives me control over updates and changing objects and code, allowing me to go to previous versions easily and prevents the dreaded “Where did that feature go?” problem. But what if the customer...
by Jonathan Halder | Aug 1, 2025 | Blogging
As you may have noticed, I haven’t been sending emails much lately. So what has happened? First off, I’m ok physically. I have been a bit overwhelmed lately with things to do both for clients as well as family and friends, which is my own darn fault. As I...
by Jonathan Halder | Jul 23, 2025 | Blogging, MS Access, TDD
I’ve heard in many of the sources I’ve read that there are 3 dials for projects and optimizing for 1 or 2 of the dials will affect the other(s). The dials are: Cost (Expensive vs Inexpensive) Quality (High with lower bugs, Low with more bugs or inefficient...