Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
What Would File Hashing Be Used For?
I had a question from a reader - Jim P - about the usage of yesterday's function. Why did I write it and what am I using it for? I wrote a response to Jim and thought I would share with the group: In yesterday's message (Hashing An Array of Files), the function shown...
Hashing An Array of Files
I wrote a function to take a number of files I wanted hashed as an array of fully qualified file paths. The function then iterates over the array to build a giant PowerShell command containing all the paths, parses the output of PowerShell and returns a dictionary...
When to use Access, Excel, or both!
This article from Microsoft Support discusses the differences between using Microsoft Access and Excel for managing data, helping users decide which tool is best suited for their needs. I've used Copilot to help me create a quick summary of the article you can use as...
Access Primer for Businesses – way more than a database
There are of course a multitude of uses for a relational database system. Remember that although natively Access defaults to storing data relationally in tables using the file based ACE system (Access Connectivity Engine), it can really use any ODBC or OLE DB...
Combining or Splitting VBA lines
There is a way to run multiple lines of code on one line in VBA and another way to separate one line of VBA code across multiple lines. I find in particular when using the Immediate Window in the VBE editor, that if I want to test a class I'm using there, I need to be...
Case Sensitivity – Not everyone types English!
I was posting some information on the Option Compare statement in Access VBA and was trying to find more information about the Option Compare Database default option and what exactly it means. From the online Microsoft VBA documentation: Option Compare Database can...
Article written with AI: Leveraging AI Chatbots to Assist in Writing VBA Code
Except for this first paragraph and my reaction at the end, the entire article below was written by Bing Copilot using the prompt: "Can you write me a 300 word article on using AI chatbots to assist writing VBA code?" I will note my reaction at the end of the article....
Are you a good customer?
I can not overstate the importance of the relationship between an Access developer / development company and the customer. If bad, this relationship will create disillusionment and disappointment on both sides of the aisle and become toxic and destructive. So what are...
Access as a low cost option
Is Microsoft Access really a low cost option? It certainly can be if you are a DIY person who already owns Microsoft Office and think of low cost as "not spending lots of cash". There is always a learning curve which takes time to work through, as well as the time it...
Writing tests for legacy code – Part 5
Yesterday's message: Writing tests for legacy code – Part 4 | Access JumpStart Here is the full code I am discussing: '@TestMethod("DeleteAction") Private Sub GivenConcreteGroupDeleteTriggered_WhenReadOnlyStatusType_RequirePassword() On Error GoTo TestFail 'Arrange:...
Writing tests for legacy code – Part 4
Yesterday's message: Writing tests for legacy code – Part 3 | Access JumpStart Before diving into the next piece of the function, the Act, here is the full code: '@TestMethod("DeleteAction") Private Sub...
Writing tests for legacy code – Part 3
See yesterday's message in the archive here: Writing tests for legacy code – Part 2 | Access JumpStart For reference, here is the full function I am discussing. '@TestMethod("DeleteAction") Private Sub...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994