TDD – 021 – Prepping SVN Working Copy on the Laptop

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

Yesterday, I wrote up to the point of creating the new SVN repository on my server and checking it out to a folder on my laptop. Next I need to configure the structure of the repository. SVN repositories really can have any structure you want. Think of the whole thing...

TDD – 020 – Crossover Article… working on 2 computers

by Jonathan Halder | Dec 26, 2023 | Versioning

I sometimes find myself working at my laptop at times. It’s great working for yourself in that respect. You can theoretically choose the time and place you want to work (well, to a point). And my laptop is great in terms of CPU and memory. It’s actually...

TDD – 019 – An interface? What’s the big deal?

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

I was excited yesterday to discover that I wanted an interface and how this might help with my TDD. I refactored the FormListener to have an interface. Here’s why I’m so excited. Now I can have a live version of the Listener AND a test version of the...

TDD – 018 – Eureka! My first interface.

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

Ok, so I got a test started up here, let’s try to continue and see where it goes: ‘@TestMethod(“FormListener”) Private Sub FormListenerRaisesBoundDataChangedEvent() FormListenerTest.Setup NewForm NewForm.TestText = “NewThing” End...

TDD – 017 – Trying to get to the next simplest test (and failing)

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

I am trying to build a Form Auditing class using TDD. So far I’ve created a FormListener class which hooks into the Form BeforeUpdate handler. Then I created a FormIterator class which will eventually iterate through the Form object during the BeforeUpdate event...

TDD – 016 – Begin to Create the Iterate method

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...