by Jonathan Halder | Oct 14, 2025 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
I utilized a couple of library routines I built to manage an Excel export. Step 1 – Get an Excel object from a function which opens a particular xlsx file as a template, then copies it to a new file name given by the function. I have other functions which can...
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 3, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Ever wonder what a developer running a sole proprietorship does? Here’s a little snapshot of my life this week. This week i’ve been up to a couple of things: I’ve updated a client to provide a button to their navigation to open a particular query....
by Jonathan Halder | Aug 27, 2025 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
A few years ago I wrote a routine to copy an Access query or table to a block of Excel cells because I was having issues with DoCmd.TransferSpreadsheet not being able to always do what I needed. I found that copying the entire recordset to an array variable and then...
by Jonathan Halder | Aug 26, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today I had a request from a customer with a database used for What If scenarios to allow him to do either do updates from the main tables consistently or to boot all other users out of their front ends so that he can do an update when one is required. The system is...
