by Jonathan Halder | Nov 29, 2023 | MS Access, MS Access VBA Coding, TDD
It is time to think about the next test. What I’d like to do is start capturing changes to the form fields. Probably the simplest and easiest way to do that is to create a collection of form field information inside the FormListener object to start storing...
by Jonathan Halder | Nov 28, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
The test-driven development cycle is: Create failing test for the behavior you are wanting. Create just enough code for the test to pass. Refactor – meaning reorganize the code without changing any functionality. And you just keep repeating that over and over...
by Jonathan Halder | Nov 27, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
So far, the test Creates a new Form Listener object Creates a new Form object as a Test Form Opens the Test Form Runs the Setup method of the Form Listener object Updates a field on the Test Form Saves the Test Form Record Checks the BeforeUpdateTriggered Property of...
by Jonathan Halder | Nov 22, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
Sorry, had to recognize the 007 reference with in my title. James Bond. Anyway, I am working on a test to check whether the TestForm’s BeforeUpdate event is getting fired and the FormListener object is seeing it. My initial thought here is to add testable...
by Jonathan Halder | Nov 21, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
Could I do less to check for acceptance of a form object? So, out of morbid curiosity, I am going to see if I can just create a new Access.Form object again and open it and then pass that to the function. It would be easier for this initial test if I can and the idea...
by Jonathan Halder | Nov 20, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
Hmmm… So it turns out you can’t just create a form using: Dim aNewForm As New Access.Form I was trying to simply pass a new form object to a class I eventually want to hook into it’s event forms. So, next I tried to actually create a blank form in...
