by Jonathan Halder | Apr 9, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding
Today I started working through using a transaction to cover another complex series of database transactions. One of my customers was receiving an error message that a record was already deleted during an import. In this case, the import process takes a while and if...
by Jonathan Halder | Apr 8, 2025 | Blogging, MS Access, MS Access VBA Coding
Today’s Access adventure involved refactoring code as an evolution from getting a particular set of line item records associated with a file to be processed when that file was selected from another form. In the first iteration of the code for testing, I was...
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...
