TDD – 022 – Configuring and preparing OASIS-SVN

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

I now have a blank checked out copy of the trunk of the FormAuditor repository from SVN. Now it’s time to use OASIS SVN to export the project to a source folder. First I copy the Access database I’ve created to the root of the SVN working copy. I use an...

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