by Jonathan Halder | Sep 16, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Reports, MS Access VBA Coding
They sound the same, don’t they? But they aren’t!!! Often you want to control elements visibility on forms. For example, you might want to hide certain fields or buttons from view when you are adding a record instead of editing it. In a recent case for my...
by Jonathan Halder | Sep 13, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Yesterday I discussed a Combobox I was adding dummy header lines into. See that message here: The Joys of Combo Dropdown Group Headers. My combo box is multiple columns and I use the extra columns to insert data into other fields on the line when the Item Description...
by Jonathan Halder | Sep 12, 2024 | MS Access, MS Access Forms, MS Access Queries
What? Combo dropdown group headers? What voodoo is this? I have a combo box on a continuous form in an Item Description field. Each row on the continuous form can contain a line item that can be populated from different sources. There is a job estimate source where...
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...
