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...
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...
