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...
by Jonathan Halder | Oct 21, 2024 | Blogging, MS Access, MS Access VBA Coding, Versioning
When working with a particular customer, it is very beneficial to have a plan on working on their database and being able to implement your new database changes effectively. Ideally, you might have a fully automated pipeline that would allow you to test and deploy a...
