Access JumpStart 2.0 | Blog

A Rapid Development Framework for Microsoft Access

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

by Jonathan Halder | 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 can...

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

by Jonathan Halder | 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 begs the...

TDD – 059 – Add a triple state checkbox test

by Jonathan Halder | 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 only be true or false which...

TDD – 056 – Added functions to increase test readability

by Jonathan Halder | MS Access, MS Access VBA Coding, TDD

This test I refactored yesterday to use the new functions which all the tests are using. '@TestMethod("Count Changes") Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges() Dim testFormAuditor As FormAuditor, dctInput As New Scripting.Dictionary Set...

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

by Jonathan Halder | 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 I can...

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

by Jonathan Halder | 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 – 058 – Add a checkbox test

by Jonathan Halder | 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...

TDD – 055 – All count tests refactored, but final test still rather unreadable

by Jonathan Halder | MS Access, MS Access VBA Coding, TDD

Today I will refactor the remaining test from the Count group which is counting returned times the BeforeUpdate was triggered. Here is the test I am working to refactor: '@TestMethod("Count Changes") Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges()...

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

by Jonathan Halder | 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 – 060 – Using triple state checkboxes in Access

by Jonathan Halder | 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...

TDD – 057 – Tests refactored and ready to continue building more tests!

by Jonathan Halder | 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:...

TDD – 054 – Refactoring 2 more counting tests and starting on a third

by Jonathan Halder | MS Access, MS Access VBA Coding, TDD

It is time to refactor the remaining counting tests. Here they are pre refactor: '@TestMethod("Count Changes") Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges() Dim testFormAuditor As FormAuditor Dim testCollection As Collection Set testFormAuditor...