by Jonathan Halder | May 1, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
In my application I have a class object called “ECI_POLineController” with a method called “IsLineValid”. My job was to be able to write a test for this and I have done that. It needs to set some different values on the line to verify the...
by Jonathan Halder | Apr 30, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I had a pretty “simple” change to an application in a IsLineValid function that checks the active record on a subform to see if that line is valid. A new requirement in the application meant that the conditions changed slightly. Originally, I just added...
by Jonathan Halder | Apr 29, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
After reviewing the code further I have planned out how to break the form dependency in my code that I wish to test. The code I wish to test IsLineValid currently depends on a function inside the same class called thisForm which returns a specific type of Access form...
by Jonathan Halder | Apr 26, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I have a class called PoLineController which has a public IsLineValid method. I made a change to this method in my previous TDD article, but I didn’t test it first. I did end up refactoring it a bit. So looking back, I am going to think about how I could have...
by Jonathan Halder | Apr 24, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I want to start doing TDD when doing anything new on a client project, or even when debugging. I’m trying to use principles from “Working Effectively With Legacy Code” by Michael C Feathers, although I haven’t finished reading the book yet. For...
by Jonathan Halder | Apr 22, 2024 | MS Access, TDD
After 70 short 25 minute or so sessions of TDD with Access and RubberDuck VBA, what have I learned? I have definitely learned that this is a really big subject and a big paradigm shift in my current programming style. Thinking about how to write code to keep it under...
