by Jonathan Halder | May 1, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
If you have an interface class object and you implement several types of the object, what can you do when your object has no handler? That’s where the Null Object pattern comes into play. Here’s an example of how you could implement the Null Object Design...
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...
