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

Simple Code Kata – Reverse a string

by Jonathan Halder | Apr 29, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD

Here is another simple code kata produced for me by CoPilot. Thanks CoPilot! Task: We need a function that can reverse a given string. Examples (input → output): “hello” → “olleh” “VBA” → “ABV”...

Why use code katas?

by Jonathan Halder | Apr 24, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD

I enjoyed doing yesterday’s code kata. See that here: https://www.accessjumpstart.com/super-simple-code-kata/ So the goal was to write a function to convert an integer into a string and had 3 different situations to test. The majority of the code in...

Super Simple Code Kata

by Jonathan Halder | Apr 23, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD

Here is a starter code kata… This is practically nothing in VBA since types get auto-converted, but how might you do this taking a variable of type integer and write a function to convert it to a string type. Here is the code kata requirements along with tests...

Test Driven Development and Changing Code

by Jonathan Halder | Apr 1, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD

I’ve been a relatively recent newcomer into Test Driven Development, only starting to implement it into my projects and been working on learning it since 2023 or so. Today, my Access adventuring leads me to work on changing the behavior of custom rule of the...

Unintended Changes Deployed in an Access program

by Jonathan Halder | Mar 28, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD

Today I got an email from a customer that they couldn’t enter information into a certain form and asked me if I had it locked. Immediately, I knew I had messed up because I had made a change in my development database in which I changed that’s form...

Red, Green, Refactor vs. Specify, Encode, Fulfill

by Jonathan Halder | Mar 17, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD

I was listening to the Mob Mentality podcast on Spotify and came across this episode. Here is the YouTube link (Spotify is only audio): https://www.youtube.com/watch?v=_kL_tXiNcl4 The guest, Jason Swett, was talking about Test Driven Development and those coming into...
« 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

    • (no title)
    • Daily writing ideas
    • Types of Microsoft Access Installers and Launchers I’ve built
    • Using combo boxes to select an entry and update form fields
    • Hiding duplicate records using running totals over a group

    Recent Comments

    1. | Access JumpStart on Super Simple Code Kata
    2. Mike Wolfe on Running parallel SQL server databases for testing
    3. Custom Tags For Custom tags for form controls – reimagined code | Access JumpStart on Custom tags for form controls – the case to use them for
    4. cristianbuse on VBA function to de-dupe spaces from a string
    5. Jonathan Halder on Some vanilla VBA error handling scenarios

    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.