by Jonathan Halder | Apr 30, 2025 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
The last few days I’ve been adding lots of VBA code for updating views and tables to put new fields into my SQL Server backend. I’ve been using the MZ-Tools regular expression search and replace tool to do some heavy lifting for quoting paragraphs of SQL...
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...
by Jonathan Halder | Apr 22, 2025 | Blogging, MS Access, MS Access VBA Coding
I was looking around at some code katas today. Code katas are an exercise in coding that one can do on a repeated basis similar to practicing a move in martial arts. If you’ve seen the movie Karate Kid or any of it’s sequels or remakes, you might remember...
by Jonathan Halder | Apr 21, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
I am pivoting directions on a project. After producing what the customer asked for, he realized it was making the whole system more complicated than he wanted, but may want to revisit it in the future. Thankfully, since I use versioning, it was trivial to move back to...
