Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Headless Access and Preventing startup recovery questions
Ok, been a while since I last posted. This quarter I was really trying to revamp my processes to focus on getting billable stuff done. So my writing took a bit of a back seat while I tried to figure it out. Last week and this week I had 2 different clients that I had...
Excel VBA sorting and import routines with help from CoPilot
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...
HAL_Excel class module for exporting data to an Excel Spreadsheet
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 use the...
MZ-Tools Find and Replace carriage returns (new lines)
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...
Moving the business forward! Remembering the basics
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. Reduce...
Frustrating 64-bit ACCDE failure fix found
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...
Building Smarter Dropdowns in Access with Section Headers and De-Duping
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...
A random set of today’s interesting tasks
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...
A short foray into TDD and AI to help with a production Access database update
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...
Text File Import / Export Recipe code part 3 (implementing iImportFile)
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 interface class module....
Text File Import / Export Recipe code part 2 (AppProcedures module)
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 a file name...
Text File Import / Export Recipe code
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: btnSelectFile -...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994