by Jonathan Halder | Jan 31, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
Our next failing test will be based around getting multiple fields changed and returned within the BeforeUpdate event. ‘@TestMethod(“Verify Changes”) Private Sub WhenTwoTextFieldsChangeBeforeAndAfterValuesAreReturned() Dim testFormAuditor As...
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 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...
by Jonathan Halder | Dec 22, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I was excited yesterday to discover that I wanted an interface and how this might help with my TDD. I refactored the FormListener to have an interface. Here’s why I’m so excited. Now I can have a live version of the Listener AND a test version of the...
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...
