by Jonathan Halder | Nov 12, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
In the past 2 day’s messages I have been wrestling with calculating the height of a report. In particular the detail section of a report inside a subreport control on a form in which the report is shown in report view (not print preview). This situation creates...
by Jonathan Halder | Nov 11, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
In Friday’s message, I was working on determining the height of the detail section with a Text Box control that has the CanGrow property set to “Yes”. It is possible to determine this when displaying the report in “Print Preview” mode...
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 | Nov 5, 2024 | MS Access, MS Access VBA Coding, TDD
I had a problem with my Access program where I had separated the database from the business logic in order to test the business logic. My tests ran successfully on the business logic, but I had introduced an error on the db side creating the data in a live environment...
