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...
by Jonathan Halder | Dec 15, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Today I was working with a customer to define the outcome needed for my work on their application. The customer wanted a specific field to be updated and copied to be the same value as other products that are conceptualy the same. The form is pretty open as to how...
by Jonathan Halder | Dec 12, 2025 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Let’s say you really want Access to go slow, maybe so it was unusable, maybe so it wouldn’t even work and corrupt your databases consistently. How would you do that? First, make sure you add in a LOT of latency. So create a front end Access database that...
by Jonathan Halder | Oct 16, 2025 | Blogging, MS Access, MS Access VBA Coding
Today I spent an hour working with CoPilot on some Excel VBA code to do a custom sort that is not normally possible with the normal sorting functions, and import data from a CSV file with a system dialog to display the default choice, but allow changing it. I was...
