Access JumpStart 2.0 | Blog

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

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

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

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

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

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

Last Test Driven Development session I refactored the last test I did to make it easier to read and understand. I created a couple of helper functions to do this. Functions that would take specified inputs, update the fields, then test to see if the resulting audit...

In the last email, I was considering a function that would do all the comparisons of the before and after values of the FieldChanges dictionary in the AuditEventDetails object and the Input dictionary I created. This would return a Boolean. It sounds good as I say it...