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 28, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
Today I got an email from a customer that they couldn’t enter information into a certain form and asked me if I had it locked. Immediately, I knew I had messed up because I had made a change in my development database in which I changed that’s form...
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 26, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
One of my recent adventures in Access was to fix an issue where occasionally a class instance setup by the Form Open event was somehow getting blown away. I’m frankly not sure why. As far as I know the global variables on the form only get reset if you close and...
by Jonathan Halder | Mar 25, 2025 | MS Access, MS Access Features, MS Access Forms
So I was wrong yesterday about phone number input masks and input values. An input mask value specifies a format, whether the mask is stored in the value, and the placeholder for users to enter data into the mask. This Microsoft web site discusses the pros and cons of...
