by Jonathan Halder | Jan 12, 2024 | MS Access, MS Access VBA Coding, TDD
Last time I had just updated a test that was failing so that it would pass. What was happening is that the class initialize module was running and hooking the TestForm event after I was making the change because I had done this: Dim testFormAuditor As New FormAuditor...
by Jonathan Halder | Jan 10, 2024 | MS Access, MS Access Features, MS Access VBA Coding
Here’s a question. How can you run Access without paying for a license? Answer: Use the Access runtime version! Download and install Microsoft 365 Access Runtime – Microsoft Support The Access Runtime version exists so that if YOU develop a database...
by Jonathan Halder | Jan 10, 2024 | MS Access, MS Access VBA Coding, TDD
Ok, opened up the FormAuditor database and ran the tests. Here’s where I’m at: That test name is a mouthful! GivenFormAuditorWhenOneFieldIsChangedThenAuditorReturnsSingleListOfChanges Given: FormAuditorWhen: One Field Is ChangedThen:...
by Jonathan Halder | Jan 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
The latest test is failing due to a compiler error: ‘@TestMethod(“FormAuditor”) Private Sub GivenFormAuditorWhenNoFormIsChangedThenAuditorReturnsEmptyListOfChanges() Dim testFormAuditor As New FormAuditor Dim testDictionary As New...
by Jonathan Halder | Jan 5, 2024 | MS Access, MS Access VBA Coding, TDD
First things first, I am continuing to work on the new test and adding code so it will actually be testing the class user expectations. I would expect that if I create this Form Auditor class and don’t have any changes to any forms, I would expect that any...
by Jonathan Halder | Jan 4, 2024 | MS Access, MS Access VBA Coding, TDD
Back to testing: I am currently working on this test, which I never actually completed. ‘@TestMethod(“FormListener”) Private Sub FormListenerRaisesBoundDataChangedEvent() FormListenerTest.Setup NewForm NewForm.TestText = “NewThing”...
