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...
by Jonathan Halder | Sep 24, 2024 | MS Access, MS Access Tables, MS Access VBA Coding
I received a task today to update a demo / WIP Access system which will be upgrading an existing Access system. Many parts of the system are the same, the upgrade is meant to address importing data from a new datasource. The customer is currently using both systems...
by Jonathan Halder | Sep 23, 2024 | MS Access, MS Access Queries, MS Access VBA Coding
I’m working in Access today and I noticed that a confirmation dialog box I have set up to ask me as a developer if I really want to send an email was not working. Initially I thought it was because of a flag that was failing to get set, but that wasn’t it....
by Jonathan Halder | Sep 20, 2024 | Blogging, MS Access, MS Access VBA Coding
So, I was having an email conversation with a regular reader of my Access Adventure and he was discussing the sad lack of documentation for VBA’s internals. The engine that runs it and it’s various components. Although I have a cursory knowledge of VBA, I...
