by Jonathan Halder | May 13, 2025 | Blogging, MS Access, MS Access VBA Coding
I worked on copying some class objects and modifying behavior for them to allow the system to process different customers with different information. I am building the system based on exports from a database into a folder of CSV files. The user decides which files to...
by Jonathan Halder | May 12, 2025 | Blogging, MS Access, MS Access VBA Coding
This is a tip from experience. It is always better to work in smaller chunks and deliver them as quickly as possible than it is to take weeks, months, or gulp… years to deliver the product. The longer it takes to deliver, the less the customer will remember what...
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 8, 2025 | Blogging, MS Access
Most of the time I come up with new ideas to write about based on what Access work I have done that day. Other sources have been things I’ve been interested in like Test Driven Development, Code Katas, and using AI as some examples. Basically, now can you...
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...