by Jonathan Halder | Mar 5, 2024 | MS Access, MS Access VBA Coding, TDD
I’m going to start the next test with something simple. A new type of field. I will add a checkbox to the test form and bind it to a Yes/No field and write a test to check to see if it updates the values as expected. I added the checkbox to the form, added a new...
by Jonathan Halder | Mar 1, 2024 | MS Access, MS Access VBA Coding, TDD
With the new set of functions that I’ve refactored last time, I’m going to update the other functions to use them. So let’s go back to the first 3 counting tests and use the dictionary creation function to make them more readable. Here they are now:...
by Jonathan Halder | Feb 29, 2024 | MS Access, MS Access VBA Coding, TDD
This test I refactored yesterday to use the new functions which all the tests are using. ‘@TestMethod(“Count Changes”) Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges() Dim testFormAuditor As FormAuditor, dctInput As New...
by Jonathan Halder | Feb 28, 2024 | MS Access, MS Access VBA Coding, TDD
Today I will refactor the remaining test from the Count group which is counting returned times the BeforeUpdate was triggered. Here is the test I am working to refactor: ‘@TestMethod(“Count Changes”) Private Sub...
by Jonathan Halder | Feb 27, 2024 | MS Access, MS Access VBA Coding, TDD
It is time to refactor the remaining counting tests. Here they are pre refactor: ‘@TestMethod(“Count Changes”) Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges() Dim testFormAuditor As FormAuditor Dim testCollection As Collection...
by Jonathan Halder | Feb 26, 2024 | MS Access, MS Access VBA Coding, TDD
Last Test Driven Development session I refactored the last test I did to make it easier to read and understand. I created a couple of helper functions to do this. Functions that would take specified inputs, update the fields, then test to see if the resulting audit...
