Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Adding a deployment script to an existing Access JumpStart app (Part 4)
In the first 3 parts of the series I'm writing, I've shown the first 4 steps in a deployment script I'm writing for a customer application. Here are the steps I've gone over so far: Step 1 – Update the version number based on the latest commit to my versioning...
Adding a deployment script to an existing Access JumpStart app (Part 3)
I have created a deployment script which is meant to prepare an Access JumpStart application for a specific live production environment. Access JumpStart is the framework Steve Halder and myself use in creating Access Applications for our customers. I have already...
Adding a deployment script to an existing Access JumpStart app (Part 2)
Yesterday, I explained that the Access JumpStart system Steve Halder and I developed as a framework to use for our Access database clients has a nice little feature that allows you to set a whole set of global options and then define overrides for those options based...
Adding a deployment script to an existing Access JumpStart app (Part 1)
This writing is specific to my Access JumpStart framework I've developed alongside Steve Halder for making our development projects more reliable and less time consuming. For a particular customer, I have a local development Access environment where I make changes to...
Refactoring in VBA with RubberDuck: Remove Parameters
Ok, next let's try removing some parameters from a function and see what happens. Here is the code I set up for the test in a class module. HAL_BasicEncryption Option Compare Database Option Explicit Implements IHAL_Encryption Private Function...
Refactoring in VBA with RubberDuck: Implement Interface
I extracted an interface in the last two articles for an encryption algorithm class. It's pretty basic, but that's ok, I'm just playing with the various refactoring tools to get familiar with them and understand how they work. Now I want to implement an Interface. I'm...
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: 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...
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...
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...
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...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994