Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Using the Immediate Pane in VBA debugging
Today, I was debugging a problem where a group number was being changed on a row on a continuous form. The group number was being looked up by a query and I found the spot where I thought that was happening. By setting a breakpoint there, I was then able to examine...
Automating the Software Development Lifecycle
I was watching this YouTube video by the Access Pacific User Group by Kent Gorrell. https://youtu.be/IGv5b5XRNiQ?si=BU8zbnQGF9oyohMv I was impressed with what he did basically building a version tracking system and amongst a slew of other things, built a system to...
Working on many tasks for a customer’s database
How do you choose what to work on next for a customer? If you have a long backlog it can get somewhat dicey. Try to keep balanced between working on longer term tasks and knocking out small requests as you go. This can be tricky depending on how you code and what you...
Recovering from an Access crash thanks to backups and versioning
Today, my Access adventure was a common story you hear every once in a while and almost all of us have experienced. I was finishing up some code it had taken me about an hour to write and I selected Debug->Compile from the VBE menu. The little blue progress bar...
SQL for Single Record Matches
Today I was splitting an address out of a table in order to replace the functionality of a single embedded address to multiple addresses. I had a Job table with the fields: Job Table fields: Job_ID, Address, city_job, state_job, zip_job And I am going to be removing...
Access JumpStart – Form Resizing class
One of the features of our Access JumpStart application template is a form resizing class: This VBA class, HAL_FormResizeCls, is designed to handle the resizing of forms and their controls in Microsoft Access. Here's a summary of its functionality and how it...
CoPilot’s creative side – Merry Christmas!
For your enjoyment, a Christmas poem and an Access poem, thoughtfully and carefully written by CoPilot: The Birth of Christ On a silent night in Bethlehem, so bright,A star heralded the Savior's light.In a humble manger, love was born,Jesus Christ, on that holy morn....
Copilot helps me analyze the differences in SD OpenAI products
I'll boil it down to this: SDOpenAI API is like doing chats with CoPilot. It forgets everything between each question and the Access plugin needs to resend the context of your questions each time. It does this in the background, but doesn't know anything other than...
Figuring out when to do TDD vs simple form design
I've been sick for the past two days, and kept getting too tired to create a post for the day. So I did what I could for my clients first, then slept. 😛 I'm feeling much better today, so I'm back in the messaging chair. I ended up scrapping my idea from yesterday:...
Automated testing strategy – TDD – Unit Testing
Today I was struggling with trying to come up with tests for a new feature for an existing Access database. The feature is changing the way addresses are entered for work jobs. Basically the job structure which has had embedded address fields like street, city, state,...
2025 – Access reintegrating source control
Karl Donaubauer hosted the Access development team at his German Access Developers Conference and there are some cool things coming down the pipe for us. One of them is re-integrating source code control back into Access: https://youtu.be/dP-YljKct5M?t=943 At one time...
Access plugin SDOpenAI and OpenAI API setup
In my message yesterday, I installed the SDOpenAI plugin: Pair programming with AI – SDOpenAI – installing the plugin Today I setup an OpenAI API account (I had already done this in the past so I was beyond the free trial). I purchased $10 worth of resource. The...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994