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...
by Jonathan Halder | Nov 5, 2024 | MS Access, MS Access VBA Coding, TDD
I had a problem with my Access program where I had separated the database from the business logic in order to test the business logic. My tests ran successfully on the business logic, but I had introduced an error on the db side creating the data in a live environment...
