by Jonathan Halder | Jun 13, 2024 | MS Access, MS Access VBA Coding
According to the RubberDuck refactoriings page, the definition of the Introduce Parameter refactoring is: Introduce Parameter Select a local variable to promote to a parameter. Call sites for the containing procedure will be updated with a TODO argument, which must...
by Jonathan Halder | Jun 12, 2024 | MS Access, MS Access VBA Coding
I have discovered another source of documentation from the RubberDuck git repository which contains some descriptions of the refactoring options. Here is the link: Refactorings · rubberduck-vba/Rubberduck Wiki · GitHub According to this page, the Encapsulate Field...
by Jonathan Halder | Jun 11, 2024 | MS Access, MS Access VBA Coding
Here is another entry on the VBA RubberDuck Refactoring menu: What exactly does this mean? Initially, I was thinking the scope was a function in a module, and it would move a function closer to a function call made. I was just DEAD WRONG! It’s actually something...
by Jonathan Halder | Jun 6, 2024 | MS Access, MS Access VBA Coding
Using some sample code I was playing with in my last Refactoring article, we will see what RubberDuck does when reordering parameters. Here’s the code: HAL_BasicEncryption Option Compare Database Option Explicit Implements IHAL_Encryption Private Function...
by Jonathan Halder | Jun 5, 2024 | MS Access, MS Access Features, MS Access VBA Coding
I wrote a script to deploy my Microsoft Access application which utilizes my company’s Access JumpStart framework which is available for purchase from our store. In the previous parts I’ve explained how I’ve done the first 6 steps of my script: Step 1 – Update the...
by Jonathan Halder | Jun 4, 2024 | MS Access, MS Access VBA Coding
I wrote a script to deploy my Microsoft Access application which utilizes my company’s Access JumpStart framework which is available for purchase from our store. In the previous parts I’ve explained how I’ve done the first 5 steps of my script: Step...
