by Jonathan Halder | Aug 22, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Today I was debugging Access and was working in some complex code that iterated over a large number of records. I wanted to stop at a particular record and run through it step by step. The record could be identified by using the RS variable which represented a DAO...
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...
