TDD – 066 – Extracting a case statement, then do what?

by Jonathan Halder | Mar 20, 2024 | MS Access, MS Access VBA Coding, TDD

Per the last writing, I wanted to refactor the BeforeUpdate routine Select Case statement. Here is the code in question: Private Sub FormToAudit_BeforeUpdate(Cancel As Integer) Dim Fld As Variant, ChangeDictionary As New Scripting.Dictionary, Ctl As Access.Control For...

TDD – 065 – Deleting a test and refactor review

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...

Access Programming – What I do and Why (Automating Access Decompiles)

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...

Access Programming – What I do and Why (Test Driven Development)

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...

TDD – 064 – Finding the bound column in a form field

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...

Access Programming – What I do and Why (SQL query debugging)

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...