by Jonathan Halder | Nov 18, 2024 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding
Given a table as the persistence layer, we will use that table to save data for re-use. If there is a form bound to this table, what user interface functions does this perform? Controls bound to fields in the table are saved automatically based on various behaviors....
by Jonathan Halder | Nov 15, 2024 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding
From my message yesterday:Separating business logic, user interface, and data persistence in a real world Access app | Access JumpStartI laid out a potential structure which included a Table which would be a data persistence layer a Form which represents a user...
by Jonathan Halder | Nov 14, 2024 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding
Considering a simple app to calculate the number of payments it would take to payoff a credit card, how might I architect this in Access to optimize for separation of database, user interface, and business logic layers? Let’s consider a simple app with a table...
by Jonathan Halder | Nov 13, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
What would your strategy for splitting a form between logic and database record management? I’m honestly asking, because that’s what I’m thinking about today. I’m thinking in terms of creating tests a la TDD style work. Having business logic...
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...
