by Jonathan Halder | Aug 21, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
I decided to do some tests today, but didn’t even get to writing any yet. The issue was that I had a function tied to a button click event event inside a form which referenced various controls on the form. Normally, it’s easy to refactor this by simply...
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...
