by Jonathan Halder | Feb 29, 2024 | MS Access, MS Access VBA Coding, TDD
This test I refactored yesterday to use the new functions which all the tests are using. ‘@TestMethod(“Count Changes”) Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges() Dim testFormAuditor As FormAuditor, dctInput As New...
by Jonathan Halder | Feb 28, 2024 | MS Access, MS Access VBA Coding, TDD
Today I will refactor the remaining test from the Count group which is counting returned times the BeforeUpdate was triggered. Here is the test I am working to refactor: ‘@TestMethod(“Count Changes”) Private Sub...
by Jonathan Halder | Feb 27, 2024 | MS Access, MS Access VBA Coding, TDD
It is time to refactor the remaining counting tests. Here they are pre refactor: ‘@TestMethod(“Count Changes”) Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges() Dim testFormAuditor As FormAuditor Dim testCollection As Collection...
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 20, 2024 | MS Access, MS Access Features, MS Access Forms
Yesterday we discussed replacing the Access Splash Screen with your own custom bitmap. Today We will discuss how to launch the app without seeing the Access database window and just using your main form. The technique involves a few different Access settings and a...
