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

VS Code, AI, and Me: A Beginner’s Tale of Plugins and Possibilities

by Jonathan Halder | Jul 18, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning

In my continuing AI adventures, I have decided to attempt to use a tool called Augment Code which can analyze and index my code base via Visual Studio Code. Visual Studio Code: An open source Code Editing IDE for multiple languages with a large number of extensions....

Access Report Sorcery: Making the Last Page Play by Different Rules

by Jonathan Halder | Jul 17, 2025 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding

I had a customer with an Access database who wanted me to tack a page with completely different info and format to the last page of a main report. This main report would run in an automated fashion and is emailed to a list of users and it is also able to be run...

Persistent Intelligence (In Progress): Exploring AI Tools for Managing and Modifying Access Codebases

by Jonathan Halder | Jul 15, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning

Today, I was thinking more about using AI and Access. Particularly VBA, but I’d also like to be able to see if AI can understand my exported Access object files (I’m using OASIS SVN to export the Access objects currently, but there are other apps that can...

Playing with CoPilot for analyzing an Access database

by Jonathan Halder | Jun 30, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning

Just now I was thinking it sure would be nice if CoPilot could analyze my Access database and give me tips on things. So I tried an experiment. I asked CoPilot if it could create databases or if I could upload my database for it to analyze. It thought it would be able...

Comparing 2 data sets visually

by Jonathan Halder | Jun 20, 2025 | Blogging, MS Access, MS Access Queries, MS Access Reports, MS Access VBA Coding

I was asked by a customer to mark fields in red that changed each week in a report. So what strategy did I come up with? Well first I need to store the data from the original run of the report. The customer wants to know what changed since the last automated report...

Microsoft Access with multiple users

by Jonathan Halder | Jun 16, 2025 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding

This is an entire planet to explore in and of itself. There are multiple layers of sharing when it comes to creating Access databases and applications with multiple users. Although fraught with land mines, users can use the same Access front end at the same time. This...
« 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.