by Jonathan Halder | Jul 23, 2025 | Blogging, MS Access, TDD
I’ve heard in many of the sources I’ve read that there are 3 dials for projects and optimizing for 1 or 2 of the dials will affect the other(s). The dials are: Cost (Expensive vs Inexpensive) Quality (High with lower bugs, Low with more bugs or inefficient...
by Jonathan Halder | Jul 1, 2025 | Blogging, MS Access, MS Access Features, TDD, Versioning
Yesterday, I had found a method for CoPilot to see an entire database. In order to do this, all the objects of the database need to be exported to text files. This is an undocumented and unsupported feature of Access, but it has been there for a long time and is what...
by Jonathan Halder | Jun 12, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
Ok, so this really doesn’t qualify as test driven development because a key of that discipline is to automate your tests. That means you actually would have a set of functions that would automatically test various things as you create them and you leave those...
by Jonathan Halder | May 20, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD, Versioning
So, I am beginning again to move into a place where I will attempt to use some AI tools. What will this do for me? Here are some of the things I’m hoping it will help with: Allowing me to delegate simple coding tasks like functions and subroutines. Get...
by Jonathan Halder | Apr 29, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
Here is another simple code kata produced for me by CoPilot. Thanks CoPilot! Task: We need a function that can reverse a given string. Examples (input → output): “hello” → “olleh” “VBA” → “ABV”...
by Jonathan Halder | Apr 24, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
I enjoyed doing yesterday’s code kata. See that here: https://www.accessjumpstart.com/super-simple-code-kata/ So the goal was to write a function to convert an integer into a string and had 3 different situations to test. The majority of the code in...