by Jonathan Halder | Mar 15, 2024 | MS Access, MS Access Features, MS Access VBA Coding, TDD
I first have to let you know that I am NOT actually doing Test Driven development on live projects consistently. I have created some tests for client work in the past before coding, but it has been quite rare. I like the idea of Test Driven Development and would like...
by Jonathan Halder | Mar 14, 2024 | MS Access, MS Access VBA Coding, TDD
I’m going to add a data element to our collection so that the user of our Form Auditor class will have the bound field name from the ControlSource property. First I will add a new test to check for this additional field in order to have a failing test, then I...
by Jonathan Halder | Mar 13, 2024 | MS Access, MS Access VBA Coding
Today I had an annoying error message occurring under cetain circumstances while creating a temporary table for an Access report to use. The error message was: Run-time error ’94’: Invalid use of Null Here are the steps I took to debug the error. Make sure...
by Jonathan Halder | Mar 12, 2024 | MS Access, MS Access VBA Coding, TDD
I am currently exploring the phenomenon that happens to different fields in a form that are bound to the same underlying table field. For an example I have two text fields (TestText and TestTextAlso) on a form that are both bound to the same underlying TestText column...
by Jonathan Halder | Mar 11, 2024 | MS Access, MS Access VBA Coding, TDD
Last time I was curious about this topic. What happens in the BeforeUpdate event to two separate controls that are bound to the same column? So rather than wonder what would happen… how about we test for the behavior we would want in this situation… which...
