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...
by Jonathan Halder | May 16, 2024 | MS Access, MS Access Features, MS Access Forms
I have been slack in writing for the past week. The main obstacle is that I had a great suggestion about writing more to my target market in terms of Access JumpStart. This turned out to be a big pivot in my thought process, and I’m not sure I’m there yet....
