by Jonathan Halder | Apr 7, 2025 | Blogging, MS Access, MS Access Queries
In SQL Server you can count up the distinct values in a column of a query using syntax like: SELECT SalesPersonID, COUNT(DISTINCT CustomerID) As NumberOfDistinctCustomersServed FROM ClosedSales GROUP BY SalesPersonID This will give you the number of unique customers...
by Jonathan Halder | Apr 4, 2025 | Blogging, MS Access, MS Access VBA Coding
First of all I am notoriously bad at knowing when to quit. I keep trying things thinking I’m almost there and that I’ll get that code working in the next 5 minutes. Then 3 hours later I have a huge mess and it’s not done yet with me scratching my...
by Jonathan Halder | Apr 3, 2025 | Blogging, MS Access, MS Access VBA Coding
Today’s adventure in Access was a problem my customer was having with an imported file. Their shipment requests were being supplied via electronic delivery and then they send a confirmation via the same electronic delivery system. The recipient of the shipments...
by Jonathan Halder | Apr 2, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding, Versioning
In today’s adventure, I have a complex application I am updating from an older version of our Access Jump Start application template from when we were calling it RDF (Rapid Development Framework). I am doing this so I will have access to some of the newer...
by Jonathan Halder | Apr 1, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
I’ve been a relatively recent newcomer into Test Driven Development, only starting to implement it into my projects and been working on learning it since 2023 or so. Today, my Access adventuring leads me to work on changing the behavior of custom rule of the...
