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...
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 9, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
When implementing logging in your Access app, some of the things you might want to log are: Opening and closing of objects which have VBA associated with them. Typically Forms and Reports. Try to add a log message which includes the primary key when you edit or add a...
