by Jonathan Halder | Sep 24, 2025 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access Tables, MS Access VBA Coding, TDD, Versioning
Today’s adventure is using CoPilot ChatGPT-5 to create a test and code based on a production database requirement. I’m using RubberDuckVBA to do unit testing. My initial prompt to start the conversation was: I am wanting to get help with creating tests for...
by Jonathan Halder | Sep 8, 2025 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
Subform navigation systems on a form can get a little tricky at times. I am currently working on a Subform / Subreport control on a form that lists all the shipment records for a single job in order of the shipping date and time. Because the customer wanted a numeric...
by Jonathan Halder | Sep 4, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Reports, MS Access VBA Coding
Don’t be afraid to refactor something if it’s getting too complicated. One of my customers often will have new ideas for reports or forms in the Access app that would really help him make his business better and his life easier. Many times these ideas will...
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 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...
