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...
by Jonathan Halder | Jan 18, 2024 | MS Access, MS Access VBA Coding, TDD
I added a failing test to my system with 2 issues: One being that the new value didn’t get set to “”, and the second problem being that it did not consider Null any different than the new random value. Two problems we can tackle in our next episode. TDD – 033...
by Jonathan Halder | Jan 17, 2024 | MS Access, MS Access VBA Coding, TDD
Do I want the Auditor to make sure that if the control is empty with Null or empty with a 0 length string it treats them the same? Or do I want the Auditor to do strict typing? Yesterday’s Article I have decided that the Form Auditor class itself will do strict...
