by Jonathan Halder | Jun 12, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
Ok, so this really doesn’t qualify as test driven development because a key of that discipline is to automate your tests. That means you actually would have a set of functions that would automatically test various things as you create them and you leave those...
by Jonathan Halder | Jun 10, 2025 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
I find myself annoyed with my younger self as I slough through multiple views and queries to slightly change some things so that I can get a similar result set with slightly different customer requirements. Simply put, in this case, the main issue is that I have 2...
by Jonathan Halder | Jun 9, 2025 | Blogging, MS Access, MS Access VBA Coding
When I get to work on other people’s databases (or my own for that matter) I have a couple of main principles I use to test my solution. I don’t consider it done until it passes these 2 tests: My first principle is to simplify the users’ job. The...
by Jonathan Halder | Jun 6, 2025 | Blogging, MS Access, MS Access VBA Coding
Especially when you begin creating, it’s often easy to think that copying and modifying objects to do the new thing that you’re being asked to do is a good way to go. It’s fast and builds on previous code and concepts, but often can easily result in...
by Jonathan Halder | Jun 5, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
Today I updated a form and added a new filter textbox to it to allow the customer to specify part of a part number and filter a list of CSV files that contain that part number. It’s actually already processed these files and the data for all part numbers is in a...
by Jonathan Halder | Jun 3, 2025 | Blogging, MS Access, MS Access VBA Coding
Today I was considering how best to setup automated upgrades for a customer for when I deploy a new version of their Access suite. I say suite because it is together about 9 Access programs that all get installed using an install file that I create using SSE Install...
