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...
by Jonathan Halder | Apr 5, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
It’s time to add a new test: ‘@TestMethod(“Initialize”) Private Sub WhenThereIsAForm_ThenItCanBeAssigned() Dim testFormAuditor As FormAuditor Set testFormAuditor = New FormAuditor testFormAuditor.Init Forms(“TestForm”) End Sub This...
by Jonathan Halder | Mar 25, 2024 | MS Access, MS Access VBA Coding, TDD
Back to getting a failing test. I am wanting to make sure that the user can configure any particular form to use this FormAuditor class easily, so I want my next tests to indicate that. Here are a few scenarios I already had on my test list: Easily load the form...
by Jonathan Halder | Mar 22, 2024 | MS Access, MS Access VBA Coding, TDD
I’m making a new test. So far I’ve just copied an old test and here it is so far: ‘@TestMethod(“Verify Changes”) Private Sub WhenControlTypesAcceptedListChanges_ThenControlTypesInListChecked() Dim dctInputs As New Scripting.Dictionary,...
by Jonathan Halder | Mar 21, 2024 | MS Access, MS Access VBA Coding, TDD
I’ve decided to use an array instead of a collection. I have to loop over either to search for the element, the array will be small, and it is native to the VBA language and I don’t have to create a new object. Also, I am just planning on using the array...
