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...
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 17, 2024 | MS Access, MS Access Features, MS Access Queries
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...
