CustomTags – changing to utilize RubberDuckVBA testing

by Jonathan Halder | Feb 25, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD

Ok, so to use test driven development here, I will start writing tests to describe the behaviors of the control I want and then code to make the tests pass. I copied the code from the module from last time with the TestCustomTags Sub to a new Test module I created...

Custom tags for form controls – Beginning to code the solution

by Jonathan Halder | Feb 21, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding

So I’m doing some proof of concept here. I want to use a starting syntax like the following in the Debug.Print line: Public Sub TestCustomTags() Dim testCT As CustomTags Set testCT = New CustomTags Dim ctl As Access.Control Set ctl = Form_TestForm.TestControl...

Custom tags for form controls – further refining a desired syntax

by Jonathan Halder | Feb 20, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding

So far my idea just kind of sucks. It’s ok, sometimes one just has a sucky idea. I think what I’d really like to be able to do is something like this: ‘ In a form object, wouldn’t it be nice to be able to do this? Private Sub Form_Load()...

Custom Tags For Custom tags for form controls – reimagined code

by Jonathan Halder | Feb 19, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding

I’m imagining what the new code might look like based on the last message I wrote on this topic. Here is the URL to the previous article: https://www.accessjumpstart.com/custom-tags-for-form-controls-the-case-to-use-them-for/ So given this kind of syntax: Dim...

Using RecordsetClone to modify other records on a subform

by Jonathan Halder | Feb 18, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding

Today I wrote up a quick proof of concept for a task to propagate changes to other records that matched a key of a cost reference number and a phase number. In this case, I wrote a before update event routine to check to see if there were other records that met the...

The Proxy Design Pattern in Access VBA

by Jonathan Halder | Feb 17, 2025 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD

I’ve been reading a book about Design Patterns. This particular book has Java sample code. It is written by Robert C Martin and is called Agile Software Development Principles, Patterns, and Practices. I had been trying to wrap my brain around separating...