by Jonathan Halder | Feb 15, 2024 | MS Access, MS Access Features, Versioning
What is Access JumpStart? Thanks for asking. Access JumpStart is our collective work as a two man programming outfit to share common code for our apps across multiple clients, architectures, and configurations. Steve and I call it a framework. It originally was named...
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...