TDD – 015 – To Assert or Not To Assert

by Jonathan Halder | Dec 15, 2023 | MS Access, MS Access VBA Coding, TDD

Our test driven development continues! We are creating a Form Auditor and so far have a basic form listening class and now we need a class which will iterate over a form and collect the Old and New values of fields that are different. I am creating a skeleton of the...

TDD – 014 – A new structure beginning to congeal

by Jonathan Halder | Dec 12, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

So in order for the FormListener class to raise an event which passes all the bound field’s old and new values, or chooses the ones that have changed, I am feeling like I can create a testable object to do that. Something like a FormIterator. It should be run in...

TDD – 013 – Pausing to re-evaluate my goals

by Jonathan Halder | Dec 11, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

Ok, so in the last installment, I told myself to stop and review this. I think my last couple of tests were going down the wrong path. Let me review what I am trying to achieve again: Here’s what I said in post 1: I am going to start by attempting to design a...

TDD – 012 – Passing Code vs Overthinking

by Jonathan Halder | Dec 4, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

A big part of Test Driven Development is to write code that passes a test without overthinking things. In my last test I wrote, it’s pretty clear it will not stand up to the next couple of tests one might think of. The test is making sure that the count of...

TDD – 011 – Testing variable types and refactoring

by Jonathan Halder | Dec 1, 2023 | MS Access, MS Access VBA Coding, TDD

I am currently in a failing test state: I see that the expected and actual values are not the same type in the test. This means that I asserted a 1 of type Long would be a 1 of type Integer. I believe that’s the default type of 1. VBA is usually pretty nice in...

TDD – 010 – Design and the next test

by Jonathan Halder | Nov 29, 2023 | MS Access, MS Access VBA Coding, TDD

It is time to think about the next test. What I’d like to do is start capturing changes to the form fields. Probably the simplest and easiest way to do that is to create a collection of form field information inside the FormListener object to start storing...