by Jonathan Halder | Mar 19, 2024 | MS Access, MS Access VBA Coding, TDD
First I need to review a test that is failing: That test was not the last test I wrote which was the Verify Info Fields category test to return the new ControlSource property I added. The failing test was actually another test I wrote to see if two fields bound to the...
by Jonathan Halder | Mar 18, 2024 | MS Access, MS Access Features, MS Access VBA Coding
I work on my own computers, a laptop and a desktop to do my main work on customer Access databases. Once I am at a point where I have something I want to give to the customer I want that process to work as quickly and as seamlessly as possible. Part of this process is...
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...
