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 | Nov 1, 2024 | Blogging, MS Access, MS Access VBA Coding
I gave copilot this prompt: Rewrite this VBA function using Uncle Bob’s SOLID principles:Function time_() ‘****************** Dim v_a As Integer Dim v_b As Integer Dim v_c As Integer ‘- – – – – – – – –...
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 29, 2024 | Blogging, MS Access, MS Access VBA Coding
When I was younger, I was a staunch DIYer (Do-it-yourself) programmer. Granted, this was a great advantage in many ways in those days. I didn’t have to spend money on add-ins or have to spend time to learn how to use them. I also didn’t have to spend money...
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...
