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...
by Jonathan Halder | Jan 9, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
I had written some code for a client using the onChange and onKeyPress events of a ComboBox to be able to determine when the user had simply typed some text in, or whether they had selected an item from the dropdown list using the dropdown event. This was because the...
by Jonathan Halder | Jan 8, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today I had a weird problem that took me about 2 hours to track down. I had a normal form in Continuous view that was not triggering an error of any kind, but would not write to the record. It could see all the records, you could navigate to them, and I had a delete...
