by Jonathan Halder | Feb 12, 2025 | Blogging, MS Access, MS Access Features
Access is an interesting animal. It’s a Windows desktop app included in the Microsoft Office family originally touted as a low-code no-code relational database management tool. It received decent attention for a while, getting relatively serious new features...
by Jonathan Halder | Jan 29, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
So the reason I was getting strange behavior in some tests I was running was because there was a third party class which responsibly used an error handling scheme used in it’s tests which required an error being raised with Err.Raise to pass up to the calling...
by Jonathan Halder | Jan 28, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
I am running into a situation in someone else’s code where an Err.Raise call is not getting handled by any of the upstream calling functions and ends up calling the main VBA system debugger displaying the VBA error dialog. I was trying to recreate the problem...
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 14, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
One strategy I have used to run automated processes with Access is to use Command Line switches. So to start up Access you use the Access program “MsAccess.exe”, usually with the full path to it, then use the database you are opening as an argument, and...
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...
