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...
by Jonathan Halder | Jan 29, 2024 | MS Access, MS Access VBA Coding, TDD
My next test will be to make a single change to a field’s value from “start” to “end” and verify that the name of that field and those values are returned. Me – last time And away we go. A failing test to change the field’s value from one known value to...
