Access JumpStart 2.0 | Email Archive
A Rapid Development Framework for Microsoft Access
Email Archive
How Do You Eat an Elephant? Tackling Complex Access Requirements
How do you eat an elephant? One bite at a time. In this case, I am thinking about complex requirements customers have. The first stage in dealing with complex requirements like: "I want main line items on my PO with subline items related to each of those main line...
Access Automation: Using Microsoft Graph for Email Delivery
Kudos to Maria Barnes and her code to utilize Microsoft Graph. Here is her open source project on github.com: VBA-MicrosoftGraph/README.md at master · mbarnesatbbs/VBA-MicrosoftGraph · GitHub This allowed me (along with her instructions and some help from CoPilot) to...
Talking it out with your customer
Today I was working with a customer to define the outcome needed for my work on their application. The customer wanted a specific field to be updated and copied to be the same value as other products that are conceptualy the same. The form is pretty open as to how...
How to cripple Microsoft Access
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 you will run...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994