Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Guiding principles
When I get to work on other people's databases (or my own for that matter) I have a couple of main principles I use to test my solution. I don't consider it done until it passes these 2 tests: My first principle is to simplify the users' job. The second is to...
Copying and modifying code / forms / objects
Especially when you begin creating, it's often easy to think that copying and modifying objects to do the new thing that you're being asked to do is a good way to go. It's fast and builds on previous code and concepts, but often can easily result in nasty hacks that...
Two Form Filtering strategies
Today I updated a form and added a new filter textbox to it to allow the customer to specify part of a part number and filter a list of CSV files that contain that part number. It's actually already processed these files and the data for all part numbers is in a long...
Poking around to find new customers
Ok, so I'm not a professional marketer at all and this is NOT a marketing list. I don't think 🙂 Tell me if you think I'm wrong. Anyway, I am trying out social networking on LinkedIn and Alignable to see if I can find some business owners or department heads who are...
Setting up an automated Access App upgrade strategy
Today I was considering how best to setup automated upgrades for a customer for when I deploy a new version of their Access suite. I say suite because it is together about 9 Access programs that all get installed using an install file that I create using SSE Install...
Sometimes one makes dumb mistakes 😛
What did I do today? I have a complex order form I built according to customer specs. They have several different scenarios and ways in which they can open an order in the form and I did not build the form so that it is capable of opening multiple orders at once. In...
Form filtering using unbound text boxes continued
I started using the SDOpenAI plugin to write a class that could take multiple form control input values and create a string for a filter output for a form. It did a simple and respectable job in accomplishing my task, but as I started implementing it, I started...
Basic Filtering with form text boxes
There's tons of good articles out there on this. Just a couple of notes, I had a customer asking me about filtering a subform in a datasheet view. They were using Ctrl-F to bring up the Access find box which they were lamenting was not set to partial content by...
CDO email using a queue and emailing from one server
I have a couple clients now who had emails they wanted to either send out on a scheduled basis, like every Thursday, and/or when certain events occurred, like importing a certain type of file with certain types of part numbers, or a po is updated and causes a project...
The importance of being disciplined
When I began my business doing consulting, the freedom was great. I could do anything I wanted whenever I wanted. No one was there to look over my shoulder to tell me what to do. I knew I had to deliver things, but it seemed that was always a job for "Future Jon"....
SDOpenAI Access Add In – controlling context through selecting text.
I have been playing a little bit with the SDOpenAI Access Add In. In particular testing what context is being sent to the API in different situations. When your cursor has nothing selected, the general chat context will send the current line your cursor is on. When...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994