by Jonathan Halder | May 16, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
I have a form a customer wanted to track changes in. Not all changes, just the “important” ones which is a business definition. No problem. So what was my approach? I built a class object that could store the original state of a recordset, then compare...
by Jonathan Halder | May 9, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Today I had fun with Access events and closing the database with unfinished changes to a form that needed to stay open and prevent Access from closing. The problem was that records were able to get to an invalid state by: Users re-opening a form to edit a new record....
by Jonathan Halder | May 6, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
Yesterday I mentioned a technique I use to hide repeated report fields: https://www.accessjumpstart.com/hiding-duplicate-records-using-running-totals-over-a-group/ Today, I will discuss another technique I use to update fields on a form based on columns in a combo box...
by Jonathan Halder | Apr 15, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today’s work was to fix logic errors in my application. The problem is that overlapping data in files that normally deletes the older data and replaces it with the newer data is replacing all the older data even though it is earlier than what appears in the...
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...
