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