by Jonathan Halder | Apr 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
The other day I was coding an Access Form which displays a file list to choose files to import into the database. I had created the following components: An Access Form named: ImportForm A Class Module to handle a full list of files available for importing and...
by Jonathan Halder | Apr 5, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
It’s time to add a new test: ‘@TestMethod(“Initialize”) Private Sub WhenThereIsAForm_ThenItCanBeAssigned() Dim testFormAuditor As FormAuditor Set testFormAuditor = New FormAuditor testFormAuditor.Init Forms(“TestForm”) End Sub This...
by Jonathan Halder | Apr 2, 2024 | MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
One of my clients was occasionally getting a 2455 error in Access: Run-time error ‘2455’: You entered an expression that has an invalid reference to the property Form/Report. What was happening in this case was that the user had minimized Access and then...
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...
