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...
by Jonathan Halder | Jan 17, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
In other languages, when you build a class, there are things called constructors which can take parameters when you instantiate the class as an object in order to initiate it. This is very handy, as you can abbreviate what you need to do into a much smaller number of...
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...
