by Jonathan Halder | Jan 6, 2025 | Blogging, MS Access, MS Access VBA Coding
It’s important to have a process to deploy an application to a client or customer. If you don’t have a process in place, Whatever method you use is not reproducible every time. I prefer to automate my deployment process as much as possible. I’d...
by Jonathan Halder | Jan 3, 2025 | Blogging, MS Access, MS Access VBA Coding
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...
by Jonathan Halder | Jan 2, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
I was watching this YouTube video by the Access Pacific User Group by Kent Gorrell. I was impressed with what he did basically building a version tracking system and amongst a slew of other things, built a system to automatically update SQL backends (with extensive...
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 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 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...
