by Jonathan Halder | Sep 5, 2024 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables, MS Access VBA Coding
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...
by Jonathan Halder | Sep 4, 2024 | Blogging, MS Access, MS Access VBA Coding
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...
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...
