by Jonathan Halder | Aug 14, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
Today I spent the time I would have taken to write an article to start reviewing the 8th light’s TDD starter’s guide: https://8thlight.com/insights/getting-started-tdd-practical-guide I’m excited to practice more TDD. But the lion’s share of...
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 8, 2025 | MS Access, TDD
I’ve been listening to a podcast called Mob Mentality on Spotify. I just get the audio there but I think there’s a YouTube channel. I’m still interested in mob and pair programming, even though I petered out when trying to organize one. (Sorry Peter...
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...
