by Jonathan Halder | Dec 11, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
Ok, so in the last installment, I told myself to stop and review this. I think my last couple of tests were going down the wrong path. Let me review what I am trying to achieve again: Here’s what I said in post 1: I am going to start by attempting to design a...
by Jonathan Halder | Dec 4, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
A big part of Test Driven Development is to write code that passes a test without overthinking things. In my last test I wrote, it’s pretty clear it will not stand up to the next couple of tests one might think of. The test is making sure that the count of...
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...
