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 7, 2025 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
Ok, so in some cases, VBA is nice to you and destroys variable references you use when you utilize the SET keyword. Let’s say you do something like this: Dim dbObj As DAO.Database Set dbObj = CurrentDb This is in the context of some kind of function or sub, or...
by Jonathan Halder | Dec 12, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
I am going to test out the free version of the SDOpenAI Access plugin to see how well it works to pair program with. The web site is in German, but I had no problem downloading the executable file (albeit with multiple warning prompts from Edge about being a file that...
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...