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...
by Jonathan Halder | Feb 19, 2024 | MS Access, MS Access Features
There are some nice little features of Access and some nice tutorials and articles out there to help launch an Access app without making it obvious to the user it is an Access app. The first one I’m going to discuss today is: Replacing the Access Splash Screen...
by Jonathan Halder | Feb 16, 2024 | MS Access, MS Access Features
I started a series on Access JumpStart yesterday with an overall summary of what we were trying to accomplish with it within our company and as a product. Internally we are currently using AJS version 2.1, and we are packaging it up now to update on our web site. For...