TDD – 006 – Mocks and Fakes and Tests, oh my!

by Jonathan Halder | Nov 21, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

Could I do less to check for acceptance of a form object? So, out of morbid curiosity, I am going to see if I can just create a new Access.Form object again and open it and then pass that to the function. It would be easier for this initial test if I can and the idea...

TDD – 005 – Passing a form to our listener part 2

by Jonathan Halder | Nov 20, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

Hmmm… So it turns out you can’t just create a form using: Dim aNewForm As New Access.Form I was trying to simply pass a new form object to a class I eventually want to hook into it’s event forms. So, next I tried to actually create a blank form in...

Access Programming – What I do and Why (source control)

by Jonathan Halder | Nov 17, 2023 | MS Access, MS Access VBA Coding

So in terms of Access Programming, I have over the years, built up tools and practices I use which help me develop better, faster, and more efficiently. Many of these tools and practices were developed specifically in order to solve recurring problems. Ok, so...

TDD – 004 – Passing a form to our listener part 1

by Jonathan Halder | Nov 16, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

Ok, so now we have just created a test for creating an instance of a FormListener class, but there’s nothing in the class yet. What do we want to test next? I need to think about the next bit of functionality I will want in this class in a way that I can test...

TDD – 003 – Getting our first test to pass

by Jonathan Halder | Nov 15, 2023 | MS Access, MS Access VBA Coding, TDD

So we have created our first test and it is failing. Opening up the RubberDuckVBA Test Explorer and running all the tests shows us our failing test: Now it’s time to make it pass. To do this I’m going to Create a new Class Module using the Insert -> Class...

TDD – 002 – initial design and first test

by Jonathan Halder | Nov 14, 2023 | MS Access, MS Access VBA Coding, TDD

Design for a form auditing object Ok, so before I can write any tests, I have to think just a little bit about what I want to create so that I can start writing meaningful failing tests that will move me toward where I want this to go. Whew! Sounds kind of confusing,...