Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Adding screen only buttons to a report for printing and adjusting report behavior as a modal dialog
Today I was working on a file importer in Access again for my customer. This importer is using the technique of throwing an error as discussed in my previous message. My next task was to display a report if the file being imported raised the error and allow the...
Handling Application level errors in Access VBA
I have a condition that to the application owners of an Access app is an error condition. If they try to import a parts file and the part pricing isn't in the part pricing table already, it should stop the import and tell the user to add the pricing information before...
Need a jumpstart, and crazy queries
I definitely need an Access jumpStart! Haha. Just a word about realigning priorities. I've really been re-vamping my internal business structure and schedule. While I was figuring things out, I have been away from writing, but I think I'm ready to come back now, so my...
New Year, new opportunities. Let’s go!
2026 has arrived! Wow, I never got used to it being 2025. So here we are at the beginning of a new year which many people view as a new start or the beginning of a new cycle. For me, it's important to review my goals from the prior year. What did I accomplish? What...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994