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 7, 2025 | Blogging, MS Access, MS Access VBA Coding
I’m going to need to be updating one of my applications soon which is a suite of apps packaged using the excellent installer tool: SSEsetup: https://ssesetup.com/ This tool creates installers for Windows programs, but has specific features which directly...
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 | May 5, 2025 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding
I was using a quick technique today to hide certain fields on a report detail section that were repeating. There is a very quick solution to this in which you can use the “Hide Duplicates” property in the Format properties of a text box let’s say....
by Jonathan Halder | May 2, 2025 | Blogging, MS Access, MS Access VBA Coding
Sometimes, I can be too clever for myself. My future self that is. Fancy queries that do everything I need can be satisfying to write, but sometimes the tradeoff is complexity in the query that makes it difficult to understand and update as needed. Then if you have...
by Jonathan Halder | May 1, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
If you have an interface class object and you implement several types of the object, what can you do when your object has no handler? That’s where the Null Object pattern comes into play. Here’s an example of how you could implement the Null Object Design...
