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 Jonathan Halder | Mar 7, 2022 | MS Access Forms, MS Access Queries
This error occurs because, drum-roll please…. The setting for this property is too long. So in this particular case, the developer was trying to create a long SQL string using multiple UNIONs with a complex query and trying to set this string to the RowSource...
by Jonathan Halder | Jun 18, 2021 | MS Access, MS Access Forms, MS Access Queries
I recently experienced a frustrating issue that had me scratching my head for a while. I had a PO form with a Line Item subform and I could edit lines and when I tried to delete a line it was removed from the subform. BUT… If I closed and reopened the same PO...
