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 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...
