by Jonathan Halder | Jan 28, 2025 | MS Access, MS Access Features, MS Access VBA Coding, TDD, Versioning
As I was working on some code to store custom tags related to controls, I thought it would be nice to use a dictionary object. Dictionary objects work by storing a value of some kind along with a key to find it. The Scripting.Dictionary object uses the VBScript...
by Jonathan Halder | Dec 20, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
I’ve been sick for the past two days, and kept getting too tired to create a post for the day. So I did what I could for my clients first, then slept. 😛 I’m feeling much better today, so I’m back in the messaging chair. I ended up scrapping my idea...
by Jonathan Halder | Dec 17, 2024 | Blogging, MS Access, MS Access VBA Coding, TDD
Today I was struggling with trying to come up with tests for a new feature for an existing Access database. The feature is changing the way addresses are entered for work jobs. Basically the job structure which has had embedded address fields like street, city, state,...
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 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...
