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

Access Programming – What I do and Why (Find and Replace)

by Jonathan Halder | Dec 18, 2023 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding

Refactoring code is something I do often. Trying to find ways to make things simpler and more readable are two reasons of many that I do this. As I work on code and refactor it, I find myself continually, daily, using tools to find and replace code, and not quite as...

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