by Jonathan Halder | May 30, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
I started using the SDOpenAI plugin to write a class that could take multiple form control input values and create a string for a filter output for a form. It did a simple and respectable job in accomplishing my task, but as I started implementing it, I started...
by Jonathan Halder | May 29, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
There’s tons of good articles out there on this. Just a couple of notes, I had a customer asking me about filtering a subform in a datasheet view. They were using Ctrl-F to bring up the Access find box which they were lamenting was not set to partial content by...
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...
