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...
by Jonathan Halder | Sep 16, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
So yesterday’s form code: Text File Import / Export Recipe code | Access JumpStart refers to functions in a module called AppProcedures. What’s in this module? Used with the first form button: GetRawFileName() Function returns a string with a full path and...
by Jonathan Halder | Sep 15, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
A reader commented on my email last week asking about the code. So here’s some nuts and bolts in reference to the article: A Reusable Recipe for Importing and Exporting Text Files in Access. The user interface is a form with 2 buttons and 2 text boxes:...
by Jonathan Halder | Sep 10, 2025 | Blogging, MS Access
I was thinking today about productivity. Not in the abstract, but in the “what am I actually wasting time on?” kind of way. You know the drill—those little things that pile up and eat away at your day before you even realize it. One of the big ones for me is time...
