by Jonathan Halder | Jan 28, 2025 | MS Access, MS Access Features, MS Access VBA Coding, TDD, Versioning
As I was working on some code to store custom tags related to controls, I thought it would be nice to use a dictionary object. Dictionary objects work by storing a value of some kind along with a key to find it. The Scripting.Dictionary object uses the VBScript...
by Jonathan Halder | Jan 16, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
We all re-use code in one form or another. Perhaps it begins by copying and pasting routines into a text file. Perhaps you’ve used people’s online repositories of code that they place online, or you share your code in forum posts and search there for code...
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 16, 2024 | Blogging, MS Access, MS Access VBA Coding, Versioning
Karl Donaubauer hosted the Access development team at his German Access Developers Conference and there are some cool things coming down the pipe for us. One of them is re-integrating source code control back into Access: https://youtu.be/dP-YljKct5M?t=943 At one time...
