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...
by Jonathan Halder | Jan 21, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Yesterday, I talked about creating a class for custom tags for form controls. In particular, I have a class I’ll call FormResizer. I want FormResizer to be able to set and read top, left, width, and height properties for the original attributes of the control so...
by Jonathan Halder | Jan 20, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Every Access control has a tag property which stores a string. I’ve used this property before to store information about a control I’ll need later. Kind of a poor man’s custom property. Let’s say you want to store something in that tag...
