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...
by Jonathan Halder | Feb 14, 2024 | MS Access, MS Access VBA Coding, TDD
In the last email, I was considering a function that would do all the comparisons of the before and after values of the FieldChanges dictionary in the AuditEventDetails object and the Input dictionary I created. This would return a Boolean. It sounds good as I say it...
