Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Refactoring in VBA with RubberDuck: Extract Interface part 2
I attempted to Extract Interface on a class module yesterday called HAL_Outlook in my code library. Here's yesterday's article: Refactoring in VBA with RubberDuck: Extract Interface part 1 | Access JumpStart The dialog came up and it "worked" and created the new...
Refactoring in VBA with RubberDuck: Rename a class
Update 6/12/2024: Found another source of documentation On RubberDuckVBA's github page they do have a section that mentions each of the refactoring options: https://github.com/rubberduck-vba/Rubberduck/wiki/Refactorings Original article I'm going to spend a little...
Getting back on the horse, and form layout label auto configure issue
I have been slack in writing for the past week. The main obstacle is that I had a great suggestion about writing more to my target market in terms of Access JumpStart. This turned out to be a big pivot in my thought process, and I'm not sure I'm there yet. Daily...
TDD – 075 – Breaking Dependencies for Testing (part 2)
I had a pretty "simple" change to an application in a IsLineValid function that checks the active record on a subform to see if that line is valid. A new requirement in the application meant that the conditions changed slightly. Originally, I just added the checks...
Refactoring in VBA with RubberDuck: Extract Interface part 1
The next refactoring item in the menu is "Extract Interface": This applies to a class module, so in order for it to be active, we need to have a class module selected. We would want to extract an interface in order to abstract an existing class to create a dumbed down...
Wait, what’s that? “Clean Project”, courtesy of MZ-tools
I've probably clicked on this button before, but I must say, I have absolutely no idea off the top of my head what this does: I noticed it today in the VBE editor. "Clean Project". No 3 dots. I'm going to try to click it and see what happens! Ok, I clicked it. It...
TDD – 077 – Breaking Dependencies for Testing (part 4)
I have not written anything for a week. Bad me. So, the nice thing about testing is that I was able to fire up my tests and run them and I see right where I was working when I left off last time. Continuing from last time, I am going to add the same form getting...
TDD – 074 – Breaking Dependencies for Testing
After reviewing the code further I have planned out how to break the form dependency in my code that I wish to test. The code I wish to test IsLineValid currently depends on a function inside the same class called thisForm which returns a specific type of Access form...
Refactoring in VBA with RubberDuck: Extract Method
The next refactoring to look at is "Extract Method" located here in the VBA IDE RubberDuck menu: I'm going to look at this code and attempt to use this on OldMatches to extract the line to a new function to make it easier to read. Here is the code I am going to...
Access and ODBC: a quick overview
One great thing about Access is all the various ways it can connect to data in tables. Using ODBC, Access can connect to anything with an ODBC driver that you can install. I've done connections using datasource names as well as DSN-less connections to SQL Server. A...
TDD – 076 – Breaking Dependencies for Testing (part 3)
In my application I have a class object called "ECI_POLineController" with a method called "IsLineValid". My job was to be able to write a test for this and I have done that. It needs to set some different values on the line to verify the function returns a correct...
TDD – 073 – This Might Get Messy!
I have a class called PoLineController which has a public IsLineValid method. I made a change to this method in my previous TDD article, but I didn't test it first. I did end up refactoring it a bit. So looking back, I am going to think about how I could have done...

Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994
info@halderconsulting.com