by Jonathan Halder | Jul 1, 2025 | Blogging, MS Access, MS Access Features, TDD, Versioning
Yesterday, I had found a method for CoPilot to see an entire database. In order to do this, all the objects of the database need to be exported to text files. This is an undocumented and unsupported feature of Access, but it has been there for a long time and is what...
by Jonathan Halder | Jun 30, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
Just now I was thinking it sure would be nice if CoPilot could analyze my Access database and give me tips on things. So I tried an experiment. I asked CoPilot if it could create databases or if I could upload my database for it to analyze. It thought it would be able...
by Jonathan Halder | Jun 26, 2025 | Blogging, MS Access, MS Access Queries
I had never heard of a cross join, but was exploring ways to put some complex calculations into other calculations in a nested fashion on SQL server. SQL does not allow you to reference a calculated column to calculate another column, but this method allows you to add...
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...
