by Jonathan Halder | Jan 30, 2026 | Blogging, MS Access, MS Access VBA Coding
I didn’t end up working on anything Access today, but I thought I’d throw some thoughts at you on programming in Access VBA: Always set the Option Explicit statement at the top of every module. There’s an Access setting to always include it when...
by Jonathan Halder | Jan 27, 2026 | Blogging, MS Access, MS Access Tables, MS Access VBA Coding
Tracking down problems in your code can be a bear, especially when it complex and handling multiple situations. For example, today I was trouble shooting an import file that was not importing properly. I’ve so far tracked it down to the logic that determines...
by Jonathan Halder | Jan 26, 2026 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding
Today I was working on a file importer in Access again for my customer. This importer is using the technique of throwing an error as discussed in my previous message. My next task was to display a report if the file being imported raised the error and allow the...
by Jonathan Halder | Jan 23, 2026 | MS Access, MS Access Forms, MS Access Reports, MS Access Tables, MS Access VBA Coding
I have a condition that to the application owners of an Access app is an error condition. If they try to import a parts file and the part pricing isn’t in the part pricing table already, it should stop the import and tell the user to add the pricing information...
by Jonathan Halder | Jan 22, 2026 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
I definitely need an Access jumpStart! Haha. Just a word about realigning priorities. I’ve really been re-vamping my internal business structure and schedule. While I was figuring things out, I have been away from writing, but I think I’m ready to come...
by Jonathan Halder | Dec 16, 2025 | Blogging, MS Access, MS Access VBA Coding
Kudos to Maria Barnes and her code to utilize Microsoft Graph. Here is her open source project on github.com: VBA-MicrosoftGraph/README.md at master · mbarnesatbbs/VBA-MicrosoftGraph · GitHub This allowed me (along with her instructions and some help from CoPilot) to...
