Access JumpStart 2.0 | Email Archive
A Rapid Development Framework for Microsoft Access
Email Archive
A few quick VBA tips for better development and deployment of your Access App
I didn't end up working on anything Access today, but I thought I'd throw some thoughts at you on programming in Access VBA: Always set the Option Explicit statement at the top of every module. There's an Access setting to always include it when creating new modules,...
Reminder: You can’t link linked Access file tables
Somehow I keep forgetting this. I keep thinking that at some time in the past I was able to link Database C to the linked tables in Database B which were linked to Database A. Why would this be helpful? My use case would be for my database table separation into...
Sharing the load – an exercise in splitting Access Files
I've decided that I'm not going to do this at the moment due to time constraints and other important features needing to be added to the database, but here's what I'll do eventually. I have one mammoth import database with one table for a file list and three more...
Simplifying Complex File Importing rules
Tracking down problems in your code can be a bear, especially when it complex and handling multiple situations. For example, today I was trouble shooting an import file that was not importing properly. I've so far tracked it down to the logic that determines whether...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994