by Jonathan Halder | Feb 19, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
I’m imagining what the new code might look like based on the last message I wrote on this topic. Here is the URL to the previous article: https://www.accessjumpstart.com/custom-tags-for-form-controls-the-case-to-use-them-for/ So given this kind of syntax: Dim...
by Jonathan Halder | Feb 18, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Today I wrote up a quick proof of concept for a task to propagate changes to other records that matched a key of a cost reference number and a phase number. In this case, I wrote a before update event routine to check to see if there were other records that met the...
by Jonathan Halder | Feb 17, 2025 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
I’ve been reading a book about Design Patterns. This particular book has Java sample code. It is written by Robert C Martin and is called Agile Software Development Principles, Patterns, and Practices. I had been trying to wrap my brain around separating...
by Jonathan Halder | Feb 13, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
In today’s adventure, I discovered what I thought was a simple change was not so simple. The system I’m working on has jobs and each job has POs written as part of doing the job. Each PO is delivered to an address which is USUALLY the job address, but not...
by Jonathan Halder | Feb 12, 2025 | Blogging, MS Access, MS Access Features
Access is an interesting animal. It’s a Windows desktop app included in the Microsoft Office family originally touted as a low-code no-code relational database management tool. It received decent attention for a while, getting relatively serious new features...
