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...
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 | Oct 13, 2025 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
Today I was pulling in some SQL code from SQL Studio I wanted to put into a string and run from a VBA routine to update some views on the production database. Because I use MZ Tools, I chose to use the find and replace function along with regular expressions to pick...
by Jonathan Halder | Oct 10, 2025 | Blogging, MS Access, Versioning
It being the 4th quarter of 2025, I’ve been doing my usual review of the last quarter and making plans for the 4th quarter. This quarter’s plan is to return to the basics of business. Reduce unnecessary or redundant tasks in order to improve productivity....
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...
