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

Allowing AI to see your whole database

by Jonathan Halder | Jul 1, 2025 | Blogging, MS Access, MS Access Features, TDD, Versioning

Yesterday, I had found a method for CoPilot to see an entire database. In order to do this, all the objects of the database need to be exported to text files. This is an undocumented and unsupported feature of Access, but it has been there for a long time and is what...

Manual test driven development

by Jonathan Halder | Jun 12, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD

Ok, so this really doesn’t qualify as test driven development because a key of that discipline is to automate your tests. That means you actually would have a set of functions that would automatically test various things as you create them and you leave those...

Preparing to use AI for programming

by Jonathan Halder | May 20, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD, Versioning

So, I am beginning again to move into a place where I will attempt to use some AI tools. What will this do for me? Here are some of the things I’m hoping it will help with: Allowing me to delegate simple coding tasks like functions and subroutines. Get...

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

    • 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!
    • When life gets overwhelming… choose to stop.

    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.