by Jonathan Halder | Apr 14, 2025 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding
Today’s adventure was to fix a bug in a menu form in which the user was getting a “This record has been deleted” error message. What was happening was that the navigation form was based on a local temp table that gets rebuilt whenever the application...
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...
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...
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...
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...
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...
