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

An example of using AI to write a function

by Jonathan Halder | Sep 11, 2024 | Blogging, MS Access, MS Access VBA Coding, TDD

Programming with AI You can shortcut some work by asking a large language model (LLM) how to do something.  If someone else out there has done it and the AI LLM has trained on it, it might even do a decent job. Today I needed to write a function that would take a...

Writing tests for legacy code – Part 5

by Jonathan Halder | Aug 19, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD

Yesterday’s message: Writing tests for legacy code – Part 4 | Access JumpStart Here is the full code I am discussing: ‘@TestMethod(“DeleteAction”) Private Sub GivenConcreteGroupDeleteTriggered_WhenReadOnlyStatusType_RequirePassword() On Error...

Writing tests for legacy code – Part 4

by Jonathan Halder | Aug 16, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD

Yesterday’s message: Writing tests for legacy code – Part 3 | Access JumpStart Before diving into the next piece of the function, the Act, here is the full code: ‘@TestMethod(“DeleteAction”) Private Sub...

Writing tests for legacy code – Part 3

by Jonathan Halder | Aug 15, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD

See yesterday’s message in the archive here: Writing tests for legacy code – Part 2 | Access JumpStart For reference, here is the full function I am discussing. ‘@TestMethod(“DeleteAction”) Private Sub...

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

    • Form filtering using unbound text boxes continued
    • Basic Filtering with form text boxes
    • CDO email using a queue and emailing from one server
    • The importance of being disciplined
    • SDOpenAI Access Add In – controlling context through selecting text.

    Recent Comments

    1. RichardRost on Why I think hourly billing is nuts
    2. Using combo boxes to select an entry and update form fields | Access JumpStart on Hiding duplicate records using running totals over a group
    3. | Access JumpStart on Super Simple Code Kata
    4. Mike Wolfe on Running parallel SQL server databases for testing
    5. Custom Tags For Custom tags for form controls – reimagined code | Access JumpStart on Custom tags for form controls – the case to use them for

    Archives

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