by Jonathan Halder | Oct 8, 2024 | MS Access, MS Access VBA Coding, TDD
If you haven’t had the pleasure of Uncle Bob Martin books or videos, you’re missing out. I’d recommend a search on YouTube for Uncle Bob’s Clean Code. I watched a lot of his videos when I had an O’Reilly subscription and that led me to...
by Jonathan Halder | Oct 4, 2024 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
The Access 97 database I was trying to get working on my 365 Access was written to scramble data in existing tables in a destructive way so that users of a forum or other developers could look at code without seeing sensitive data. I copied some large tables I had...
by Jonathan Halder | Sep 30, 2024 | Blogging, MS Access, MS Access VBA Coding
Our Access application framework that Steve and I developed and use to build our apps is called Access JumpStart. It does not include vbWatchdog by default for those who buy our framework, but it contains code to work with vbWatchdog if the developer of the app has...
by Jonathan Halder | Sep 27, 2024 | Blogging, MS Access, MS Access VBA Coding
After my message yesterday, I updated my strategy a little bit. Yesterday, I added the code to my global error handler that is always called by vbWatchdog. I created a Call Stack string variable every time there was an error regardless of how it was going to get...
by Jonathan Halder | Sep 26, 2024 | Blogging, MS Access, MS Access VBA Coding
Just a quick note today. I wanted to add the call stack to my error log messages for my client app. That way I could see the full set of calls that was causing the error and it would help me debug better. For example, if I pass bad SQL to my SQL Executing function, I...
by Jonathan Halder | Sep 25, 2024 | Blogging, MS Access, MS Access Tables, MS Access VBA Coding
I have finished coding the solution. I ended up using DAO after all. The solution grabs a collection containing info about the source and target database paths and table names. Then it loops through the collection, opens the target database, deletes the table if it...
