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 | 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 | 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...
