Access JumpStart
  • Homepage
  • Email Archive
Select Page

Writing tests for legacy code – Part 2

by Jonathan Halder | Aug 14, 2024 | MS Access, MS Access VBA Coding, TDD

See yesterday’s message in the archive here: Writing tests for legacy code – Part 1 | Access JumpStart I’m going to start breaking down the test I wrote and what I’m doing and why. Here is the whole test:...

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...
« Older Entries
Next Entries »

Recent Posts

  • Quoting Access projects
  • A few quick VBA tips for better development and deployment of your Access App
  • Reminder: You can’t link linked Access file tables
  • Sharing the load – an exercise in splitting Access Files
  • Simplifying Complex File Importing rules

Recent Comments

  1. Jonathan Halder on Reminder: You can’t link linked Access file tables
  2. Colin Riddington on Reminder: You can’t link linked Access file tables
  3. Text File Import / Export Recipe code part 3 (implementing iImportFile) | Access JumpStart on Text File Import / Export Recipe code part 2 (AppProcedures module)
  4. Text File Import / Export Recipe code part 2 (AppProcedures module) | Access JumpStart on Text File Import / Export Recipe code
  5. Text File Import / Export Recipe code | Access JumpStart on A Reusable Recipe for Importing and Exporting Text Files in Access

Archives

  • February 2026
  • January 2026
  • December 2025
  • November 2025
  • October 2025
  • September 2025
  • August 2025
  • July 2025
  • 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.