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 15, 2025 | Blogging, MS Access
Hi folks, I got a few responses to my message yesterday, so here’s a summarized version of my sales, delivery, and follow up strategies for you to take a look at. I’ll tell you up front that I follow this very poorly, but it is what I intend to do from the...
by Jonathan Halder | May 14, 2025 | Blogging, MS Access
Hourly billing uses hours to measure productivity and rates to commoditize your work. Presumption: For an Access developer (in general) they should get an average hourly rate of $X. If that Access developer wants to make more money he or she must either work more...
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...
