by Jonathan Halder | Aug 19, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding
When you need to specify date ranges in Access, remember the following helpful tips: By default, a date includes the time of midnight 00:00:00. So #1/1/2025# is equivalent to the expression #1/1/2025 00:00:00# or #1/1/2025 12:00:00 AM#. When you use Between, it always...
by Jonathan Halder | Aug 18, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
Do you know what happens if you are in an Access text box and press Ctrl-A? You might expect all the text in it to be selected like a text box on a web page or in a Word document. But it doesn’t. If you are in a text box on a form in the normal single form view...
by Jonathan Halder | Aug 15, 2025 | MS Access, MS Access VBA Coding, TDD, Versioning
I did more experimentation with Visual Studio Code today and the free Copilot Github and Cogent extensions. Copilot Github interfaces with the Github site Copilot feature which offers a free version. I also got the Cogent extension which acts as an agent for Copilot...
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 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...
