by Jonathan Halder | Mar 6, 2024 | MS Access, MS Access VBA Coding, TDD
Now I am going to add a triple state checkbox to the form. I have added a new text field that can be nullable, and bound a new “TestCheckTripleState” checkbox to it. The reason for this is that a “Yes/No” Access field cannot be null. It can...
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...
