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...
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...
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...
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...
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,...
