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