Nested Error Handling – Example code and what happens

by Jonathan Halder | Jan 30, 2025 | Blogging, MS Access, MS Access VBA Coding

So this is my latest nested error test code. You can put it in any public code module and run MainProcedure to see what it will do. The thing to do here is to see how Access will behave in various scenarios and the code paths that execute and the ones that...

VBA Class errors and Break in Class Module option

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

More VBA Error handling scenarios using Err.Raise

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

Custom tags for form controls – the case to use them for

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

SQL Server query to check for normalization in row columns

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

SQL field value swapping

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