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...
by Jonathan Halder | Apr 23, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
Here is a starter code kata… This is practically nothing in VBA since types get auto-converted, but how might you do this taking a variable of type integer and write a function to convert it to a string type. Here is the code kata requirements along with tests...