by Jonathan Halder | Mar 22, 2024 | MS Access, MS Access VBA Coding, TDD
I’m making a new test. So far I’ve just copied an old test and here it is so far: ‘@TestMethod(“Verify Changes”) Private Sub WhenControlTypesAcceptedListChanges_ThenControlTypesInListChecked() Dim dctInputs As New Scripting.Dictionary,...
by Jonathan Halder | Mar 21, 2024 | MS Access, MS Access VBA Coding, TDD
I’ve decided to use an array instead of a collection. I have to loop over either to search for the element, the array will be small, and it is native to the VBA language and I don’t have to create a new object. Also, I am just planning on using the array...
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...
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...
