by Jonathan Halder | Mar 28, 2024 | MS Access, MS Access Features, MS Access Reports, MS Access VBA Coding
Sounds intriguing, doesn’t it? So what do I mean by running Access headless? I am referring to the term headless as it refers to running a machine without user intervention as an automated process. For example, I have some reports that get emailed out at certain...
by Jonathan Halder | Mar 27, 2024 | MS Access, MS Access Queries, MS Access VBA Coding
Me: Write a humorous limerick about ChatGPT failing to do what is expected. ChatGPT: There once was a bot named ChatGPT, Whose answers could often betray. Asked for a rhyme, it stuttered in time, And left folks in quite the disarray. It pondered and whirred with great...
by Jonathan Halder | Mar 26, 2024 | MS Access, MS Access Queries, MS Access VBA Coding
Today I worked on optimizing a query for a client. it wasn’t super long, about 2 seconds, but that was enough to make a noticeable delay for the users running the database. I wanted to make it a little snappier. It ended up boiling down to one thing, but first I...
by Jonathan Halder | Mar 25, 2024 | MS Access, MS Access VBA Coding, TDD
Back to getting a failing test. I am wanting to make sure that the user can configure any particular form to use this FormAuditor class easily, so I want my next tests to indicate that. Here are a few scenarios I already had on my test list: Easily load the form...
by Jonathan Halder | Mar 22, 2024 | MS Access, MS Access VBA Coding, TDD
I’m making a new test. So far I’ve just copied an old test and here it is so far: ‘@TestMethod(“Verify Changes”) Private Sub WhenControlTypesAcceptedListChanges_ThenControlTypesInListChecked() Dim dctInputs As New Scripting.Dictionary,...
by Jonathan Halder | Mar 21, 2024 | MS Access, MS Access VBA Coding, TDD
I’ve decided to use an array instead of a collection. I have to loop over either to search for the element, the array will be small, and it is native to the VBA language and I don’t have to create a new object. Also, I am just planning on using the array...
