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 26, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
I wrote a couple of times last week about custom tags and creating a class that could store custom tag information. I am further refining the requirements of the class using a real world example of something I will be using it for. I’m bringing in an enum here...
by Jonathan Halder | Jan 23, 2025 | Blogging, MS Access, MS Access Queries
If you have a table with duplicated rows, a common requirement is to try to normalize those rows by extracting distinct information from each row, placing it into another table, and relating them with an ID. But how do you find if there are any differences between...
by Jonathan Halder | Jan 22, 2025 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
I’ll get back to working on the custom tags class tomorrow. Today I want to share a solution I worked out in order to swap numeric values in an Access DAO SQL statement. So, I had a need to import records into a table where there may be existing records of the...
