by Jonathan Halder | Dec 30, 2024 | Blogging, MS Access, MS Access VBA Coding, 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...
by Jonathan Halder | Dec 27, 2024 | Blogging, MS Access, MS Access Queries
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...
by Jonathan Halder | Dec 26, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
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...
by Jonathan Halder | Dec 24, 2024 | Blogging, MS Access
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...
by Jonathan Halder | Dec 23, 2024 | MS Access, MS Access Features, MS Access VBA Coding
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...
by Jonathan Halder | Dec 20, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
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...
