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 11, 2025 | Blogging, MS Access, MS Access Queries, MS Access Reports, MS Access VBA Coding
There is no way to directly place Passthrough SQL into a Report RecordSource property. Reports want DAO recordsources and in some cases, need a table object to work off of. However, if you are using SQL server and want to utilize a SQL view, you can link it as a table...
by Jonathan Halder | Feb 7, 2025 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
Ok, should have done a screen shot, and I could go back and recreate it and get one, but not in the time I have right now… 😀 I was working in an app and had a Class outside of a form that had a function to get a reference to the form by name if it had been lost....
by Jonathan Halder | Feb 6, 2025 | Blogging, MS Access, MS Access VBA Coding
Thanks to Cristian Buse a list subscriber and amazing VBA programmer. He replied to the message yesterday about duplicates and pointed me to this StackOverflow question and answer:...
