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...
by Jonathan Halder | Aug 16, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
Yesterday’s message: Writing tests for legacy code – Part 3 | Access JumpStart Before diving into the next piece of the function, the Act, here is the full code: ‘@TestMethod(“DeleteAction”) Private Sub...
by Jonathan Halder | Aug 15, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
See yesterday’s message in the archive here: Writing tests for legacy code – Part 2 | Access JumpStart For reference, here is the full function I am discussing. ‘@TestMethod(“DeleteAction”) Private Sub...
by Jonathan Halder | Aug 14, 2024 | MS Access, MS Access VBA Coding, TDD
See yesterday’s message in the archive here: Writing tests for legacy code – Part 1 | Access JumpStart I’m going to start breaking down the test I wrote and what I’m doing and why. Here is the whole test:...
