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,...
by Jonathan Halder | Nov 13, 2023 | MS Access, MS Access VBA Coding, TDD
Why do we want to use Test Driven Development? It is less error prone, producing better code which is more reliable and able to be verified from multiple paths. It allows us to express our intent in the form of a test. This forces us to create a better design. It...
by Steven Halder | Dec 5, 2022 | MS Access, MS Access Features, MS Access VBA Coding
You can control how your project is compiled. Have one “source base” that you use for multiple purposes, environments, or in multiple “modes” of operation. You can use Microsoft defined Compiler Constants and you can define your own....
