by Jonathan Halder | Nov 27, 2024 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
In the following linked message, I started creating a form and within the form code module I created some local variables to store a class object for accounts and then used the Form Current event to test the form to make sure it was valid before running the Account...
by Jonathan Halder | Nov 26, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Some things you do when designing forms inherently reset the VBA environment. This takes all your existing object variables in that form and resets them. That’s why I often use a function to refer to an object to check to make sure it exists before I use it so I...
by Jonathan Halder | Nov 25, 2024 | Blogging, MS Access VBA Coding
Ok, a while back I asked you about TDD and doing a bootcamp and I did not get too many responses indicating interest in that, so how about a good VBA coding practices bootcamp? I’m thinking about going over practices suggested by Uncle Bob and would start with...
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...
