by Jonathan Halder | Mar 7, 2025 | Blogging, MS Access, MS Access VBA Coding
When you want to view the contents of a dictionary object in the VBA locals window, it turns out you just can’t. It shows the Dictionary Items collection with the item number and key contents, but not the value. In order to see what’s in the dictionary,...
by Jonathan Halder | Mar 6, 2025 | Blogging, MS Access, MS Access Features, MS Access Tables
Today, I remembered a little factoid about Access database versions. You can’t link older front end Access files to newer back end Access files. My mission was to take a set of Access applications I had upgraded for one department (which is being used in...
by Jonathan Halder | Mar 5, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
Today I was refactoring some tests to make them easier to write for my application. In this application, I am testing lines on a subform to make sure they have the correct values. I used a class I created called a FormGetter which uses an interface so I can create a...
by Jonathan Halder | Mar 4, 2025 | Blogging, MS Access, MS Access VBA Coding
Today’s adventure was helping a customer who had moved from an on premise Exchange server at their business to Microsoft 365 email accounts in the cloud. They needed to update their Access application with the new email settings. As I dove into the code, I found...
