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 18, 2024 | MS Access, MS Access Features, MS Access VBA Coding
As an Access developer, my typical knee jerk response to Macros is: DON’T USE MACROS, anything a macro can do, VBA can do! However, there are a couple of things macros can be used for that VBA actually can’t do. — GASP — WHAT??? One thing...
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 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...
