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

TDD – 063 – Thinking through the auditor and form field vs table column data changing

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

TDD – 062 – Auditing form controls bound to the same fields

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

TDD – 061 – Radio button, Checkboxes, and Toggle Buttons, Oh my!

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

TDD – 060 – Using triple state checkboxes in Access

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