Access JumpStart
  • Homepage
  • Blog
Select Page
  • Homepage
  • Blog

Writing tests for legacy code – Part 1

by Jonathan Halder | Aug 13, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD

As I am continuing on my Test Driven Development journey, I am starting to learn how to write tests as I add new features to my code. A recent example would be a requirement to ask for a password if the user was trying to delete a line in an order. There are...

TDD – 078 – Updating Form Auditor class requirements

by Jonathan Halder | Jun 26, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

I now have a real-world scenario for requirements for this class. Requirements are coming from customer requests and then interpreted into a list for myself. Test Driven Development then takes requirements and you translate them into tests (one at a time). Just...

Refactoring in VBA with RubberDuck: Implement Interface

by Jonathan Halder | May 27, 2024 | MS Access, MS Access VBA Coding, TDD

I extracted an interface in the last two articles for an encryption algorithm class. It’s pretty basic, but that’s ok, I’m just playing with the various refactoring tools to get familiar with them and understand how they work. Now I want to implement...

TDD – 077 – Breaking Dependencies for Testing (part 4)

by Jonathan Halder | May 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

I have not written anything for a week. Bad me. So, the nice thing about testing is that I was able to fire up my tests and run them and I see right where I was working when I left off last time. Continuing from last time, I am going to add the same form getting...

TDD – 076 – Breaking Dependencies for Testing (part 3)

by Jonathan Halder | May 1, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

In my application I have a class object called “ECI_POLineController” with a method called “IsLineValid”. My job was to be able to write a test for this and I have done that. It needs to set some different values on the line to verify the...

TDD – 075 – Breaking Dependencies for Testing (part 2)

by Jonathan Halder | Apr 30, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

I had a pretty “simple” change to an application in a IsLineValid function that checks the active record on a subform to see if that line is valid. A new requirement in the application meant that the conditions changed slightly. Originally, I just added...
« Older Entries
Next Entries »

Get a Daily Email

An email loaded with my tips and musings.

    We won't send you spam. Unsubscribe at any time.

    Recent Posts

    • Comparing 2 data sets visually
    • Stay on target…
    • Access file backends with multiple users – locking
    • Microsoft Access with multiple users
    • Working in an Agile way…

    Recent Comments

    1. Neil Sargent on Two Form Filtering strategies
    2. RichardRost on Why I think hourly billing is nuts
    3. Using combo boxes to select an entry and update form fields | Access JumpStart on Hiding duplicate records using running totals over a group
    4. | Access JumpStart on Super Simple Code Kata
    5. Mike Wolfe on Running parallel SQL server databases for testing

    Archives

    • June 2025
    • May 2025
    • April 2025
    • March 2025
    • February 2025
    • January 2025
    • December 2024
    • November 2024
    • October 2024
    • September 2024
    • August 2024
    • July 2024
    • June 2024
    • May 2024
    • April 2024
    • March 2024
    • February 2024
    • January 2024
    • December 2023
    • November 2023
    • December 2022
    • March 2022
    • January 2022
    • June 2021
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020

    Categories

    • Blogging
    • MS Access
    • MS Access Features
    • MS Access Forms
    • MS Access Queries
    • MS Access Reports
    • MS Access Tables
    • MS Access VBA Coding
    • TDD
    • Uncategorized
    • Versioning
    Copyright © Halder Consulting Inc.