by Jonathan Halder | Aug 13, 2025 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding
I was doing more complex report work today in Access. I had need to determine if my sub-report on another sub-report was running as a subreport or not. There is the case in development where I’m just testing it, but when it is running as a sub-report it needs to...
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...
