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

TDD – 056 – Added functions to increase test readability

by Jonathan Halder | Feb 29, 2024 | MS Access, MS Access VBA Coding, TDD

This test I refactored yesterday to use the new functions which all the tests are using. ‘@TestMethod(“Count Changes”) Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges() Dim testFormAuditor As FormAuditor, dctInput As New...

TDD – 055 – All count tests refactored, but final test still rather unreadable

by Jonathan Halder | Feb 28, 2024 | MS Access, MS Access VBA Coding, TDD

Today I will refactor the remaining test from the Count group which is counting returned times the BeforeUpdate was triggered. Here is the test I am working to refactor: ‘@TestMethod(“Count Changes”) Private Sub...

TDD – 054 – Refactoring 2 more counting tests and starting on a third

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

It is time to refactor the remaining counting tests. Here they are pre refactor: ‘@TestMethod(“Count Changes”) Private Sub WhenTwoFieldsAreChangedThenReturnTwoEntryListOfChanges() Dim testFormAuditor As FormAuditor Dim testCollection As Collection...

TDD – 053 – Refactoring the previous tests to use the new functions

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

Last Test Driven Development session I refactored the last test I did to make it easier to read and understand. I created a couple of helper functions to do this. Functions that would take specified inputs, update the fields, then test to see if the resulting audit...

Customizing Access: Open without Access window displayed

by Jonathan Halder | Feb 20, 2024 | MS Access, MS Access Features, MS Access Forms

Yesterday we discussed replacing the Access Splash Screen with your own custom bitmap. Today We will discuss how to launch the app without seeing the Access database window and just using your main form. The technique involves a few different Access settings and a...
« Older 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

    • Breaking the Triangle: Can You Really Have It All in Access Software Projects?
    • VS Code, AI, and Me: A Beginner’s Tale of Plugins and Possibilities
    • Access Report Sorcery: Making the Last Page Play by Different Rules
    • Persistent Intelligence (In Progress): Exploring AI Tools for Managing and Modifying Access Codebases
    • Don’t let a “perfect storm” get you down!

    Recent Comments

    1. RichardRost on Breaking the Triangle: Can You Really Have It All in Access Software Projects?
    2. Jonathan Halder on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    3. Colin Riddington on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    4. Neil Sargent on Two Form Filtering strategies
    5. RichardRost on Why I think hourly billing is nuts

    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.