by Jonathan Halder | Jun 2, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
What did I do today? I have a complex order form I built according to customer specs. They have several different scenarios and ways in which they can open an order in the form and I did not build the form so that it is capable of opening multiple orders at once. In...
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...
