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...
by Jonathan Halder | Jan 26, 2024 | MS Access, MS Access VBA Coding, TDD
Ok, time to review the list and pick something else to start testing. I did spend some time in the article posted by Kent Beck last time: Canon TDD – by Kent Beck – Software Design: Tidy First? (substack.com) I’m going to have to review it some more...
