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...
by Jonathan Halder | Nov 16, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
Ok, so now we have just created a test for creating an instance of a FormListener class, but there’s nothing in the class yet. What do we want to test next? I need to think about the next bit of functionality I will want in this class in a way that I can test...
