by Jonathan Halder | Sep 11, 2024 | Blogging, MS Access, MS Access VBA Coding, TDD
Programming with AI You can shortcut some work by asking a large language model (LLM) how to do something. If someone else out there has done it and the AI LLM has trained on it, it might even do a decent job. Today I needed to write a function that would take a...
by Jonathan Halder | Sep 10, 2024 | Blogging, MS Access, MS Access VBA Coding
In Part 3 (Refactoring the function PS_GetFileHashes (Part 3) | Access JumpStart) we arrived at this code with helper functions and a helper class: Function PS_GetFileHashes(aFiles As Variant, sHashAlgorithm As String) As Scripting.Dictionary Dim retVal As New...
by Jonathan Halder | Sep 9, 2024 | Blogging, MS Access
Within about an hour this morning I had 6 customers communicating with me this morning via email right before an hour long customer meeting. I whipped off answers as needed, scheduled calls for later in the week, blended up some code fixes and researched buggy...
by Jonathan Halder | Sep 5, 2024 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables, MS Access VBA Coding
So first things first. It is not recommended that you use spaces or special characters in your table names as it can cause problems referencing them or cases that are ambiguous and may cause unintended results in the code. But maybe you have used them in the...
by Jonathan Halder | Sep 4, 2024 | Blogging, MS Access, MS Access VBA Coding
I’ll continue refactoring today, here’s where I ended up in yesterday’s message. It’s the main function that’s been split up into 1 helper function to test the Hash and make sure it’s available, otherwise display a message box. And...
