by Jonathan Halder | Sep 20, 2024 | Blogging, MS Access, MS Access VBA Coding
So, I was having an email conversation with a regular reader of my Access Adventure and he was discussing the sad lack of documentation for VBA’s internals. The engine that runs it and it’s various components. Although I have a cursory knowledge of VBA, I...
by Jonathan Halder | Sep 19, 2024 | Blogging, MS Access, MS Access VBA Coding
There are a number of looping structures in VBA. Here is a quick cheat sheet: Loop Types:For <var> = <start> To <end> (Step <amount to add>) / Next <var> For Each <itm> In <array / collection> / Next <itm> Do While...
by Jonathan Halder | Sep 17, 2024 | Blogging, MS Access
I’m struggling through some client work right now and finding that I have found at least 3 ways of how not to get the results I’m trying to achieve. In this case it has to do with reporting to the user everything that has changed from the beginning of...
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 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...
