by Jonathan Halder | Feb 26, 2024 | MS Access, MS Access VBA Coding, TDD
Last Test Driven Development session I refactored the last test I did to make it easier to read and understand. I created a couple of helper functions to do this. Functions that would take specified inputs, update the fields, then test to see if the resulting audit...
by Jonathan Halder | Feb 14, 2024 | MS Access, MS Access VBA Coding, TDD
In the last email, I was considering a function that would do all the comparisons of the before and after values of the FieldChanges dictionary in the AuditEventDetails object and the Input dictionary I created. This would return a Boolean. It sounds good as I say it...
by Jonathan Halder | Feb 13, 2024 | MS Access, MS Access VBA Coding, TDD
Quick question to my readers: If you know a good way of highlighting the code in an email I’d like to do that. I notice that my code in the email is not marking up properly whereas it looks better on the site itself. I’m using a WordPress feed and the...
by Jonathan Halder | Feb 12, 2024 | MS Access, MS Access VBA Coding, TDD
Here we are, refactoring this function: Private Function SetFields_ChangeThem_ReturnDictionary(dctFieldName_arrStartAndEndVals As Dictionary) As Dictionary Dim testFormAuditor As FormAuditor Dim itm As Variant For Each itm In dctFieldName_arrStartAndEndVals...
by Jonathan Halder | Feb 9, 2024 | MS Access, MS Access VBA Coding, TDD
As I continue to refactor the test, this time I am going to try to create the dictionary object I think I want to get back and pass that to a helper function which will change the fields to the before state, instantiate the FormAuditor class, run a single BeforeUpdate...
by Jonathan Halder | Feb 8, 2024 | MS Access, MS Access VBA Coding, TDD
TDD is all about small changes and then testing and making sure things continue to run. I made the mistake yesterday of trying to refactor too much at once and I ended up leaving my system in an unrunnable state. Ideally, as you are developing, each change you make is...
