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...
by Jonathan Halder | Jan 25, 2024 | MS Access, MS Access VBA Coding, TDD
Kent Beck, a father figure when it comes to Test Driven Development for many people, has an article on “Canon TDD”Canon TDD – by Kent Beck – Software Design: Tidy First? (substack.com) In this article, as I mentioned yesterday, the first thing...
by Jonathan Halder | Jan 24, 2024 | MS Access, MS Access VBA Coding, TDD
I was watching a video with Kent Beck speaking somewhere, I’m not sure which one because there were like 3 different videos. But he was categorizing coders into “lumpers” and “splitters”. I apparently am a “splitter” because...
by Jonathan Halder | Jan 23, 2024 | MS Access, MS Access VBA Coding, TDD
Given the following code, I am still refactoring it: Private Function FieldChanged(Field As Access.Control) As Boolean Dim retVal As Boolean If OnlyOneFieldIsNull(Field.OldValue, Field.Value) Then retVal = True ElseIf IsNull(Field.OldValue) And IsNull(Field.Value)...
by Jonathan Halder | Jan 22, 2024 | MS Access, MS Access VBA Coding, TDD
The title is a line from an episode of Uncle Bob’s clean code video series. He advocates refactoring until you get down to 3 lines of code per function and make sure every function is doing one thing and is clearly named. At least that’s what I got out of...