by Jonathan Halder | Jun 26, 2025 | Blogging, MS Access, MS Access Queries
This was the technique I ended up using in my query which inspired this article. Again, I had help from Copilot to author the following article about using the CTE (Common Table Expression) syntax: When writing SQL queries, especially those involving multiple layers...
by Jonathan Halder | Jun 20, 2025 | Blogging, MS Access, MS Access Queries, MS Access Reports, MS Access VBA Coding
I was asked by a customer to mark fields in red that changed each week in a report. So what strategy did I come up with? Well first I need to store the data from the original run of the report. The customer wants to know what changed since the last automated report...
by Jonathan Halder | Jun 19, 2025 | Blogging, MS Access
If you’re a Star Wars fan you might remember one of the Y-wing pilots flying through the Death Star trench, flying towards the tiny little vent he needs to shoot his torpedo into in order to take advantage of a tiny flaw that would mean the destruction of the...
by Jonathan Halder | Jun 18, 2025 | Blogging, MS Access, MS Access Tables
As an overview, a big issue with multiple users is editing the same data and tables. The issue needs to be addressed differently depending on what backend you are accessing the data from. Today we’ll start the discussion with Access file backends. Access files...
by Jonathan Halder | Jun 16, 2025 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding
This is an entire planet to explore in and of itself. There are multiple layers of sharing when it comes to creating Access databases and applications with multiple users. Although fraught with land mines, users can use the same Access front end at the same time. This...
by Jonathan Halder | Jun 13, 2025 | Blogging, MS Access
Providing feedback and getting feedback is SOOO important. My customers give me an idea of what they want. It’s often in the form of some behavior they want from a form or data modeling on a report. It’s usually pretty minimal in content with an assumption...
