by Jonathan Halder | Jan 18, 2024 | MS Access, MS Access VBA Coding, TDD
I added a failing test to my system with 2 issues: One being that the new value didn’t get set to “”, and the second problem being that it did not consider Null any different than the new random value. Two problems we can tackle in our next episode. TDD – 033...
by Jonathan Halder | Jan 17, 2024 | MS Access, MS Access VBA Coding, TDD
Do I want the Auditor to make sure that if the control is empty with Null or empty with a 0 length string it treats them the same? Or do I want the Auditor to do strict typing? Yesterday’s Article I have decided that the Form Auditor class itself will do strict...
by Jonathan Halder | Jan 16, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
Now our auditor will need to be a little smarter. We need to check the beginning and ending value of the test text field during the test in the form Before Update event. We won’t yet consider canceled BeforeUpdate events, I’ll just keep that in the back of...
by Jonathan Halder | Jan 12, 2024 | MS Access, MS Access VBA Coding, TDD
The last test I wrote which I thought would pass actually doesn’t. I wrote a test to add 2 (the many condition) dictionary entries. I think I decided to use a dictionary for saving the changes by the field name, however, the same field name would be changed...
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...
