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

Upgrading our AJS template

by Jonathan Halder | Apr 2, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding, Versioning

In today’s adventure, I have a complex application I am updating from an older version of our Access Jump Start application template from when we were calling it RDF (Rapid Development Framework). I am doing this so I will have access to some of the newer...

Dragging and dropping between Access Files

by Jonathan Halder | Mar 27, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding

Did you know that you can drag and drop items from the navigation pane in one Access database to another Access database? I used this feature today as I needed to copy a somewhat complex form to display a series of entries in a linked table in both databases filtered...

Accdb’s link to Mdb’s, but Mdb’s don’t link to Accdb’s

by Jonathan Halder | Mar 6, 2025 | Blogging, MS Access, MS Access Features, MS Access Tables

Today, I remembered a little factoid about Access database versions. You can’t link older front end Access files to newer back end Access files. My mission was to take a set of Access applications I had upgraded for one department (which is being used in...

The Proxy Design Pattern in Access VBA

by Jonathan Halder | Feb 17, 2025 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD

I’ve been reading a book about Design Patterns. This particular book has Java sample code. It is written by Robert C Martin and is called Agile Software Development Principles, Patterns, and Practices. I had been trying to wrap my brain around separating...

Just show the city from the address we chose. Simple.

by Jonathan Halder | Feb 13, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding

In today’s adventure, I discovered what I thought was a simple change was not so simple. The system I’m working on has jobs and each job has POs written as part of doing the job. Each PO is delivered to an address which is USUALLY the job address, but not...

Forms that can’t write to records – Access and it’s usually helpful Lookup_ prefix

by Jonathan Halder | Jan 8, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding

Today I had a weird problem that took me about 2 hours to track down. I had a normal form in Continuous view that was not triggering an error of any kind, but would not write to the record. It could see all the records, you could navigate to them, and I had a delete...
« 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

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