by Jonathan Halder | Jan 30, 2026 | Blogging, MS Access, MS Access VBA Coding
I didn’t end up working on anything Access today, but I thought I’d throw some thoughts at you on programming in Access VBA: Always set the Option Explicit statement at the top of every module. There’s an Access setting to always include it when...
by Jonathan Halder | Jan 29, 2026 | Blogging, MS Access, MS Access Tables
Somehow I keep forgetting this. I keep thinking that at some time in the past I was able to link Database C to the linked tables in Database B which were linked to Database A. Why would this be helpful? My use case would be for my database table separation into...
by Jonathan Halder | Jan 28, 2026 | Blogging, MS Access, MS Access Tables
I’ve decided that I’m not going to do this at the moment due to time constraints and other important features needing to be added to the database, but here’s what I’ll do eventually. I have one mammoth import database with one table for a file...
by Jonathan Halder | Jan 27, 2026 | Blogging, MS Access, MS Access Tables, MS Access VBA Coding
Tracking down problems in your code can be a bear, especially when it complex and handling multiple situations. For example, today I was trouble shooting an import file that was not importing properly. I’ve so far tracked it down to the logic that determines...
by Jonathan Halder | Jan 26, 2026 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding
Today I was working on a file importer in Access again for my customer. This importer is using the technique of throwing an error as discussed in my previous message. My next task was to display a report if the file being imported raised the error and allow the...
