by Jonathan Halder | Nov 19, 2024 | Blogging, MS Access, MS Access Tables, MS Access VBA Coding, TDD
As I think about and discuss an architecture for an Access application I was considering the data persistence layer again and thinking about why one might want to test it. For example, what if your application is meant to track historic events throughout the history...
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 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...
