by Jonathan Halder | May 30, 2024 | MS Access, MS Access VBA Coding, Versioning
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...
by Jonathan Halder | May 29, 2024 | MS Access, MS Access VBA Coding
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...
by Jonathan Halder | May 28, 2024 | MS Access, MS Access VBA Coding
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...
by Jonathan Halder | May 27, 2024 | MS Access, MS Access VBA Coding, TDD
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...
by Jonathan Halder | May 24, 2024 | MS Access, MS Access VBA Coding
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”...
by Jonathan Halder | May 23, 2024 | MS Access, MS Access VBA Coding
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...