by Jonathan Halder | Jan 31, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
Our next failing test will be based around getting multiple fields changed and returned within the BeforeUpdate event. ‘@TestMethod(“Verify Changes”) Private Sub WhenTwoTextFieldsChangeBeforeAndAfterValuesAreReturned() Dim testFormAuditor As...
by Jonathan Halder | Jan 16, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
Now our auditor will need to be a little smarter. We need to check the beginning and ending value of the test text field during the test in the form Before Update event. We won’t yet consider canceled BeforeUpdate events, I’ll just keep that in the back of...
by Jonathan Halder | Dec 19, 2023 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
Time to do more test driven development! So we left off last time thinking about doing a test to see if a dictionary object I am going to create to store the form field changes is a new object. I was trying to determine how to Assert that using RubberDuckVBA and I was...
by Jonathan Halder | Dec 18, 2023 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
Refactoring code is something I do often. Trying to find ways to make things simpler and more readable are two reasons of many that I do this. As I work on code and refactor it, I find myself continually, daily, using tools to find and replace code, and not quite as...
by Jonathan Halder | Dec 6, 2023 | MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
I’ve been discussing how I use version control in 3 previous emails / articles which you can find here: Access Programming – What I do and Why (source control) | Access JumpStart Access Programming – What I do and Why (source control part 2) | Access JumpStart Access...
by Jonathan Halder | Jun 19, 2020 | MS Access Queries, MS Access Tables
A common database issue in the world is the need to store lists of related items. This might be a Bill of Material (or BOM) for a business application to describe all the parts and assemblies needed to ship a particular product, or it might be something like meal...
