by Jonathan Halder | Mar 8, 2024 | MS Access, MS Access VBA Coding, TDD
Our next test will be to add an Option Group to the form and test that. Now Access has some weird caveats for option groups. You can have radio buttons, checkboxes, or toggle buttons in an Option Group. Each button or box can be labeled, but can only have a numeric...
by Jonathan Halder | Mar 7, 2024 | MS Access, MS Access VBA Coding, TDD
Yesterday I added a test for a triple state checkbox which should allow null, and True/False values to be set. I was reminded as I had initially tried to use an Access Yes/No field type that this does not have triple state. It can never be null, so therefore will not...
by Jonathan Halder | Mar 6, 2024 | MS Access, MS Access VBA Coding, TDD
Now I am going to add a triple state checkbox to the form. I have added a new text field that can be nullable, and bound a new “TestCheckTripleState” checkbox to it. The reason for this is that a “Yes/No” Access field cannot be null. It can...
by Jonathan Halder | Mar 5, 2024 | MS Access, MS Access VBA Coding, TDD
I’m going to start the next test with something simple. A new type of field. I will add a checkbox to the test form and bind it to a Yes/No field and write a test to check to see if it updates the values as expected. I added the checkbox to the form, added a new...
by Jonathan Halder | Mar 1, 2024 | MS Access, MS Access VBA Coding, TDD
With the new set of functions that I’ve refactored last time, I’m going to update the other functions to use them. So let’s go back to the first 3 counting tests and use the dictionary creation function to make them more readable. Here they are now:...
