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...
by Jonathan Halder | Aug 22, 2024 | Blogging, MS Access VBA Coding
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...
by Jonathan Halder | Aug 19, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
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...
