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...
by Jonathan Halder | Jan 22, 2026 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
I definitely need an Access jumpStart! Haha. Just a word about realigning priorities. I’ve really been re-vamping my internal business structure and schedule. While I was figuring things out, I have been away from writing, but I think I’m ready to come...
by Jonathan Halder | Jan 1, 2026 | Blogging
2026 has arrived! Wow, I never got used to it being 2025. So here we are at the beginning of a new year which many people view as a new start or the beginning of a new cycle. For me, it’s important to review my goals from the prior year. What did I accomplish?...
by Jonathan Halder | Dec 17, 2025 | Blogging, MS Access
How do you eat an elephant? One bite at a time. In this case, I am thinking about complex requirements customers have. The first stage in dealing with complex requirements like: “I want main line items on my PO with subline items related to each of those main...