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