by Jonathan Halder | Sep 3, 2024 | Blogging, MS Access, MS Access VBA Coding
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...
by Jonathan Halder | Sep 2, 2024 | Blogging, MS Access, MS Access VBA Coding
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...
by Jonathan Halder | Aug 30, 2024 | MS Access, MS Access VBA Coding
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...
by Jonathan Halder | Aug 29, 2024 | Blogging, MS Access, MS Access VBA Coding
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...
by Jonathan Halder | Aug 28, 2024 | Blogging, MS Access, MS Access Features
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...
by Jonathan Halder | Aug 27, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
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...
