by Jonathan Halder | Dec 19, 2023 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
Time to do more test driven development! So we left off last time thinking about doing a test to see if a dictionary object I am going to create to store the form field changes is a new object. I was trying to determine how to Assert that using RubberDuckVBA and I was...
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...
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...
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...
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...
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...
