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