Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
What are the options for OpenAI access? (as of May 2025)
The SDOpenAI Access plugin uses the OpenAI API to provide "tokens" which means the question or prompts that you use, and return results (again measured in tokens) from the OpenAI system. You are charged by the number of millions of tokens you provide to the AI which...
Microsoft Access customer form logging strategy
I have a form a customer wanted to track changes in. Not all changes, just the "important" ones which is a business definition. No problem. So what was my approach? I built a class object that could store the original state of a recordset, then compare that with a...
A day in the life
I worked on copying some class objects and modifying behavior for them to allow the system to process different customers with different information. I am building the system based on exports from a database into a folder of CSV files. The user decides which files to...
Daily writing ideas
Most of the time I come up with new ideas to write about based on what Access work I have done that day. Other sources have been things I've been interested in like Test Driven Development, Code Katas, and using AI as some examples. Basically, now can you utilize...
Access VBA AI experiments – Full version of SDOpenAI Access Plugin installed
So far, I have the SDOpenAI Access Plugin reinstalled and purchased and entered in the license number. Good deal. I was able to create a function header with a descriptive line of Public Function GetDateXDaysPriorToToday(days As Single) As Date with a single for days...
The HCI Way™ – A Dive into Agile Project Management and Sales!
Hi folks, I got a few responses to my message yesterday, so here's a summarized version of my sales, delivery, and follow up strategies for you to take a look at. I'll tell you up front that I follow this very poorly, but it is what I intend to do from the finding and...
Working in small chunks – deliver faster
This is a tip from experience. It is always better to work in smaller chunks and deliver them as quickly as possible than it is to take weeks, months, or gulp... years to deliver the product. The longer it takes to deliver, the less the customer will remember what...
Types of Microsoft Access Installers and Launchers I’ve built
I'm going to need to be updating one of my applications soon which is a suite of apps packaged using the excellent installer tool: SSEsetup: https://ssesetup.com/ This tool creates installers for Windows programs, but has specific features which directly integrate...
Preparing to use AI for programming
So, I am beginning again to move into a place where I will attempt to use some AI tools. What will this do for me? Here are some of the things I'm hoping it will help with: Allowing me to delegate simple coding tasks like functions and subroutines. Get recommendations...
Why I think hourly billing is nuts
Hourly billing uses hours to measure productivity and rates to commoditize your work. Presumption: For an Access developer (in general) they should get an average hourly rate of $X. If that Access developer wants to make more money he or she must either work more...
Checking open forms and shutting down Access from code
Today I had fun with Access events and closing the database with unfinished changes to a form that needed to stay open and prevent Access from closing. The problem was that records were able to get to an invalid state by: Users re-opening a form to edit a new record....
Using combo boxes to select an entry and update form fields
Yesterday I mentioned a technique I use to hide repeated report fields: https://www.accessjumpstart.com/hiding-duplicate-records-using-running-totals-over-a-group/ Today, I will discuss another technique I use to update fields on a form based on columns in a combo box...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994
info@halderconsulting.com