by Jonathan Halder | Nov 8, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
This property is on form and report sections and many controls like Text Boxes. This seems to be a wonderful property for automatically adjusting the height of things on a form until you make the inevitable discovery: It only works in a form when you are printing the...
by Jonathan Halder | Nov 7, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
When registering events for controls on a subform, make sure you remember that you re-register those events after reloading the subform control via the SourceObject property. In my case, I was always loading a subform initially and the Open routine on the subform...
by Jonathan Halder | Nov 6, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
My Access adventure today was helping work on a problem for a customer where they were getting errors on a form that was bound, and when opened automatically starts writing a default date and time to a record. The code checks to see if this record becomes valid as the...
by Jonathan Halder | Oct 31, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
This is an experiment today. I don’t think I’ll get fully through what I would want to do today, but I want to start a little series on using TDD along with a form in Access. What would the whole process look like from beginning to end? I’m thinking...
by Jonathan Halder | Oct 24, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
First of all, it’s good to know that you can add a report to a sub-report control on a form. If you need to display multiple groups of data for informational purposes on the form, this can be a real game changer! I have a routine I use that’s in my library...
by Jonathan Halder | Oct 17, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD, Versioning
Back 6 months ago I was asked to add new fields to check for the validity of a line item on an order. This caused me to go through a rather extensive process to break dependencies on an Access form so that I could test it without having to launch the form and build an...
