by Jonathan Halder | Dec 31, 2024 | MS Access, MS Access Features, Versioning
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...
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...
