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

TDD – 018 – Eureka! My first interface.

by Jonathan Halder | Dec 21, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

Ok, so I got a test started up here, let’s try to continue and see where it goes: ‘@TestMethod(“FormListener”) Private Sub FormListenerRaisesBoundDataChangedEvent() FormListenerTest.Setup NewForm NewForm.TestText = “NewThing” End...

TDD – 017 – Trying to get to the next simplest test (and failing)

by Jonathan Halder | Dec 20, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD

I am trying to build a Form Auditing class using TDD. So far I’ve created a FormListener class which hooks into the Form BeforeUpdate handler. Then I created a FormIterator class which will eventually iterate through the Form object during the BeforeUpdate event...

TDD – 016 – Begin to Create the Iterate method

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...

Access Programming – What I do and Why (Find and Replace)

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...

TDD – 015 – To Assert or Not To Assert

by Jonathan Halder | Dec 15, 2023 | MS Access, MS Access VBA Coding, TDD

Our test driven development continues! We are creating a Form Auditor and so far have a basic form listening class and now we need a class which will iterate over a form and collect the Old and New values of fields that are different. I am creating a skeleton of the...
« 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

    • Allowing AI to see your whole database
    • Playing with CoPilot for analyzing an Access database
    • Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    • Simplifying Complex SQL Logic with CTEs in SQL Server
    • Comparing 2 data sets visually

    Recent Comments

    1. Jonathan Halder on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    2. Colin Riddington on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    3. Neil Sargent on Two Form Filtering strategies
    4. RichardRost on Why I think hourly billing is nuts
    5. Using combo boxes to select an entry and update form fields | Access JumpStart on Hiding duplicate records using running totals over a group

    Archives

    • 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.