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 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 13, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
As I am continuing on my Test Driven Development journey, I am starting to learn how to write tests as I add new features to my code. A recent example would be a requirement to ask for a password if the user was trying to delete a line in an order. There are...
by Jonathan Halder | Aug 12, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
I watched half of a new Access Users Group video on the tree view control by Pete Poppe which I link to at the bottom of this message. I learned something new. The last time I used the Treeview control I never ended up implementing it in a customer’s project...
