by Jonathan Halder | Oct 3, 2025 | Blogging, MS Access, MS Access Features
I was updating an app launcher to use Microsoft Graph instead of legacy Sharepoint API login credentials for authentication. The transformation went very smoothly and I was able to use Microsoft CoPilot with ChatGPT-5 mode to handle a lot of the grunt work! It...
by Jonathan Halder | Sep 29, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
Over the weekend I was working on a query for a drop down list for items on a PO. The list had 2 sections: Job Estimated Items Vendor Items Each section would show up in different circumstances with different items, but usually they show up together. Each section had...
by Jonathan Halder | Sep 26, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
This is a little different than my usual email, but just decided to decompress from what I was working on today before heading into the weekend. I worked on a couple interesting things today: A Launcher app using a class object to authenticate and connect to a...
by Jonathan Halder | Sep 24, 2025 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access Tables, MS Access VBA Coding, TDD, Versioning
Today’s adventure is using CoPilot ChatGPT-5 to create a test and code based on a production database requirement. I’m using RubberDuckVBA to do unit testing. My initial prompt to start the conversation was: I am wanting to get help with creating tests for...
by Jonathan Halder | Sep 17, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Implementing an interface can only be done from a class module. The class module uses the “Implements” keyword at the top and won’t compile unless you create all the appropriate functions from the interface. Yesterday I showed the code in the...
