by Jonathan Halder | Aug 11, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables
Most of my customers that I build Access apps for have not been Access users. In other words, they tend to know very little about tables or queries or reports, design view, VBA modules and macros. This tends to make my job easier in that I don’t have to be...
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...
