by Jonathan Halder | May 22, 2024 | MS Access, MS Access VBA Coding
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...
by Jonathan Halder | May 21, 2024 | MS Access, MS Access VBA Coding
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...
by Jonathan Halder | May 20, 2024 | MS Access, MS Access VBA Coding
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!...
by Jonathan Halder | May 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
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...
by Jonathan Halder | May 1, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
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...
by Jonathan Halder | Apr 30, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
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...
