Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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 -...
Productivity Check-In: What’s Worth My Time (and What Isn’t)?
I was thinking today about productivity. Not in the abstract, but in the “what am I actually wasting time on?” kind of way. You know the drill—those little things that pile up and eat away at your day before you even realize it. One of the big ones for me is time...
A Reusable Recipe for Importing and Exporting Text Files in Access
Today I extended a class based file conversion tool. I have different text files and need to be able to import a particular text file and export it into a new format, basically doing different transformations to the line items. I did some work in the past on this for...
Navigating Multi-Page Subreports in Access—Without Losing Your Place
Subform navigation systems on a form can get a little tricky at times. I am currently working on a Subform / Subreport control on a form that lists all the shipment records for a single job in order of the shipping date and time. Because the customer wanted a numeric...
Why you’ll always have a job as an Access developer
Don't be afraid to refactor something if it's getting too complicated. One of my customers often will have new ideas for reports or forms in the Access app that would really help him make his business better and his life easier. Many times these ideas will bend and...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994