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