by Jonathan Halder | Jun 26, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I now have a real-world scenario for requirements for this class. Requirements are coming from customer requests and then interpreted into a list for myself. Test Driven Development then takes requirements and you translate them into tests (one at a time). Just...
by Jonathan Halder | Jun 17, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
I had an application today with lots of flickering on a form containing two subforms in continuous mode. When I first load the main form it flickers a little bit, sometimes longer than others (seemingly depending on where my mouse is sitting). Often moving the mouse...
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...
