by Jonathan Halder | Feb 7, 2025 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
Ok, should have done a screen shot, and I could go back and recreate it and get one, but not in the time I have right now… 😀 I was working in an app and had a Class outside of a form that had a function to get a reference to the form by name if it had been lost....
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 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 10, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Reports, MS Access VBA Coding
Another gotcha in Access is when you use a function of any kind as a query field or as a bound field on a form or report. This can also be done in Conditional Formatting fields in forms and reports. Let’s say you bind a continuous form field to the builtin...