by Jonathan Halder | May 15, 2026 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding, Versioning
I didn’t make tons of progress on my Access AI setup yesterday and today other than I started to transition one project fully to Git, the Version Control System plugin, and utilizing cursor. I’m not too far in yet, but I set up a page on my internal...
by Jonathan Halder | May 14, 2026 | Blogging, MS Access, MS Access VBA Coding, Versioning
Lots of decisions to make in this new AI world and things are still emerging. My current direction has been to move to a new IDE and away from the VBE environment for most coding tasks. I started with Visual Studio Code or VS Code (Not to be confused with plain old...
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 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 23, 2026 | MS Access, MS Access Forms, MS Access Reports, MS Access Tables, MS Access VBA Coding
I have a condition that to the application owners of an Access app is an error condition. If they try to import a parts file and the part pricing isn’t in the part pricing table already, it should stop the import and tell the user to add the pricing information...
