by Jonathan Halder | Dec 11, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
Ok, so in the last installment, I told myself to stop and review this. I think my last couple of tests were going down the wrong path. Let me review what I am trying to achieve again: Here’s what I said in post 1: I am going to start by attempting to design a...
by Jonathan Halder | Dec 6, 2023 | MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
I’ve been discussing how I use version control in 3 previous emails / articles which you can find here: Access Programming – What I do and Why (source control) | Access JumpStart Access Programming – What I do and Why (source control part 2) | Access JumpStart Access...
by Jonathan Halder | Dec 5, 2023 | MS Access
I’ve been discussing how I use version control in 2 previous emails / articles which you can find here: Access Programming – What I do and Why (source control) | Access JumpStart Access Programming – What I do and Why (source control part 2) | Access JumpStart...
by Jonathan Halder | Dec 4, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
A big part of Test Driven Development is to write code that passes a test without overthinking things. In my last test I wrote, it’s pretty clear it will not stand up to the next couple of tests one might think of. The test is making sure that the count of...
by Jonathan Halder | Dec 1, 2023 | MS Access, MS Access VBA Coding, TDD
I am currently in a failing test state: I see that the expected and actual values are not the same type in the test. This means that I asserted a 1 of type Long would be a 1 of type Integer. I believe that’s the default type of 1. VBA is usually pretty nice in...
by Jonathan Halder | Nov 30, 2023 | MS Access, MS Access VBA Coding
What is my process for working with a customer database? Let’s say I get a new database to start working with. Before I make any changes, I want to put the database into version (source) control. Why? I want to make sure I have any changes I make to the database...
