by Jonathan Halder | May 21, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
So far, I have the SDOpenAI Access Plugin reinstalled and purchased and entered in the license number. Good deal. I was able to create a function header with a descriptive line of Public Function GetDateXDaysPriorToToday(days As Single) As Date with a single for days...
by Jonathan Halder | May 20, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD, Versioning
So, I am beginning again to move into a place where I will attempt to use some AI tools. What will this do for me? Here are some of the things I’m hoping it will help with: Allowing me to delegate simple coding tasks like functions and subroutines. Get...
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 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....
