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 1, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
I’ve been a relatively recent newcomer into Test Driven Development, only starting to implement it into my projects and been working on learning it since 2023 or so. Today, my Access adventuring leads me to work on changing the behavior of custom rule of the...
by Jonathan Halder | Mar 28, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
Today I got an email from a customer that they couldn’t enter information into a certain form and asked me if I had it locked. Immediately, I knew I had messed up because I had made a change in my development database in which I changed that’s form...
by Jonathan Halder | Mar 17, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
I was listening to the Mob Mentality podcast on Spotify and came across this episode. Here is the YouTube link (Spotify is only audio): https://www.youtube.com/watch?v=_kL_tXiNcl4 The guest, Jason Swett, was talking about Test Driven Development and those coming into...
by Jonathan Halder | Mar 14, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
I thought I would update folks on my TDD progress using VBA in Access. I use the RubberDuckVBA Unit Testing component to create and run tests. You don’t need a fancy program or system like that to utilize automated testing, but I have enjoyed using it and the...
by Jonathan Halder | Mar 5, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
Today I was refactoring some tests to make them easier to write for my application. In this application, I am testing lines on a subform to make sure they have the correct values. I used a class I created called a FormGetter which uses an interface so I can create a...
