by Jonathan Halder | Feb 7, 2024 | MS Access, MS Access VBA Coding, TDD
Ok, so now why am I creating all these objects in my test? How about creating the objects I want to see returned and use those to run the test on the form and then see if it’s the same objects I get back? I kinda feel like that is making the tests brittle...
by Jonathan Halder | Feb 6, 2024 | MS Access, MS Access Features, MS Access VBA Coding, TDD
We are in a refactor cycle, so it’s time to look at my mess and see what I can do to clean it up a bit. I had to make a number of changes to the test in order to test multiple fields at once. It didn’t work with my existing function which changed a single...
by Jonathan Halder | Feb 2, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I am working on passing the test: WhenTwoTextFieldsChangeBeforeAndAfterValuesAreReturned. Right now it is getting a compile error in the FieldChanged function because in the loop over the controls I am trying to pass the variant Fld variable, which the function...
by Jonathan Halder | Feb 1, 2024 | MS Access, MS Access VBA Coding, TDD
This one is broken because I am not looping through the fields to get the correct object set up and I had hard coded the Dictionary entry with the index “TestText” Me – yesterday I am also seeing that my test isn’t actually doing what I want. The test is...
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 30, 2024 | MS Access, MS Access VBA Coding, TDD
Starting with this non-passing test: ‘@TestMethod(“Verify Changes”) Private Sub WhenTextFieldChangesBeforeAndAfterValuesAreReturned() Dim testFormAuditor As FormAuditor Dim testCollection As New Collection ChangeTestText “BeforeValue” Set...
