Access JumpStart 2.0 | Blog

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, colResults As VBA.Collection Set...

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

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

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

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

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

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

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

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