by Jonathan Halder | Nov 22, 2024 | Blogging, MS Access
Working as an independent consultant for 25 years has definitely improved my focus on working productively. I think it was after the first month of working without any supervision, that I realized that I couldn’t just do whatever I wanted and delay my actual...
by Jonathan Halder | Nov 21, 2024 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding
Now I have some code. Here’s what my form looks like so far: That contains the following module: ‘Form_frmAccounts Option Compare Database Option Explicit Private InternalAccount As AccountInterface Private Function Acct() As AccountInterface If...
by Jonathan Halder | Nov 20, 2024 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
I am currently discussing a credit card payoff application I’m working on in terms of Model-View-Control architecture in a series of messages. In this message, moving back to forms, I have built a form (user interface) which I am going to think of as the user...
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...
