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 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...
by Jonathan Halder | Aug 26, 2024 | Blogging, MS Access, MS Access VBA Coding
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...
by Jonathan Halder | Aug 23, 2024 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
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...
