by Jonathan Halder | Jan 16, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
Now our auditor will need to be a little smarter. We need to check the beginning and ending value of the test text field during the test in the form Before Update event. We won’t yet consider canceled BeforeUpdate events, I’ll just keep that in the back of...
by Jonathan Halder | Jan 15, 2024 | MS Access Forms, MS Access VBA Coding, TDD
I’m just finished with the green phase meaning all my tests pass. That means I can refactor. I do have some redundant code in my tests, so i think I will refactor them to make them a little more readable. Here are my tests now: ‘@TestMethod(“Count...
by Jonathan Halder | Jan 12, 2024 | MS Access, MS Access VBA Coding, TDD
The last test I wrote which I thought would pass actually doesn’t. I wrote a test to add 2 (the many condition) dictionary entries. I think I decided to use a dictionary for saving the changes by the field name, however, the same field name would be changed...
by Jonathan Halder | Jan 12, 2024 | MS Access, MS Access VBA Coding, TDD
Last time I had just updated a test that was failing so that it would pass. What was happening is that the class initialize module was running and hooking the TestForm event after I was making the change because I had done this: Dim testFormAuditor As New FormAuditor...
by Jonathan Halder | Jan 10, 2024 | MS Access, MS Access VBA Coding, TDD
Ok, opened up the FormAuditor database and ran the tests. Here’s where I’m at: That test name is a mouthful! GivenFormAuditorWhenOneFieldIsChangedThenAuditorReturnsSingleListOfChanges Given: FormAuditorWhen: One Field Is ChangedThen:...
by Jonathan Halder | Jan 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
The latest test is failing due to a compiler error: ‘@TestMethod(“FormAuditor”) Private Sub GivenFormAuditorWhenNoFormIsChangedThenAuditorReturnsEmptyListOfChanges() Dim testFormAuditor As New FormAuditor Dim testDictionary As New...
