by Jonathan Halder | Dec 1, 2023 | MS Access, MS Access VBA Coding, TDD
I am currently in a failing test state: I see that the expected and actual values are not the same type in the test. This means that I asserted a 1 of type Long would be a 1 of type Integer. I believe that’s the default type of 1. VBA is usually pretty nice in...
by Jonathan Halder | Nov 30, 2023 | MS Access, MS Access VBA Coding
What is my process for working with a customer database? Let’s say I get a new database to start working with. Before I make any changes, I want to put the database into version (source) control. Why? I want to make sure I have any changes I make to the database...
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...
