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...
by Jonathan Halder | Oct 31, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
This is an experiment today. I don’t think I’ll get fully through what I would want to do today, but I want to start a little series on using TDD along with a form in Access. What would the whole process look like from beginning to end? I’m thinking...
by Jonathan Halder | Oct 30, 2024 | Blogging, MS Access, MS Access VBA Coding, TDD
In a message I sent a few days ago: Test Driven Development Fakes Are Faking me out! I was lamenting that some tests I was trying to write using a fake testing object, simply were returning the values that I needed to pass the test. I’ll use a small bit of my...
by Jonathan Halder | Oct 28, 2024 | Blogging, MS Access, MS Access VBA Coding, TDD
You write a test for the behavior you want. So far so good. You have to figure out how to interface with your system to write the test though. Today, I was adding a new type of status called “Internal Hold” for an order, and the line items each can also...
by Jonathan Halder | Oct 17, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD, Versioning
Back 6 months ago I was asked to add new fields to check for the validity of a line item on an order. This caused me to go through a rather extensive process to break dependencies on an Access form so that I could test it without having to launch the form and build an...
