Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
When to use Macros vs VBA in Microsoft Access
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 you can't do with VBA...
How many ways are there to NOT do something?
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 opening an order...
Transparent = True or Visible = False?
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...
Finishing the Combobox Group Headers
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...
The Joys of Combo Dropdown Group Headers
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...
An example of using AI to write a function
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...
Refactoring the function PS_GetFileHashes (Part 4)
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...
6 Customers and a Brain Freeze
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...
Access Object Names With Spaces and NiceDLookup
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...
Refactoring the function PS_GetFileHashes (Part 3)
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 a new class that holds information...
Refactoring the function PS_GetFileHashes (Part 2)
Here's our big hairy function I'm working on to refactor and get it a little more compact. So far the following contains a new instance of the class PS_FileHashesCommand which removed some constants to their own class with two needed little methods. Those lines look...
Refactoring the function PS_GetFileHashes (Part 1)
In a recent message I referenced some changes I made to this function and included a copy of it. I mentioned that I wanted to refactor it after getting the behavior I wanted because it's rather unreadable. So let's see how I would refactor this: Function...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994