by Jonathan Halder | Jul 15, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
Today, I was thinking more about using AI and Access. Particularly VBA, but I’d also like to be able to see if AI can understand my exported Access object files (I’m using OASIS SVN to export the Access objects currently, but there are other apps that can...
by Jonathan Halder | Jul 11, 2025 | Blogging, MS Access
Following up my message yesterday, I had big plans to get some more client work done, but as it happened, I wasn’t able to accomplish what I initially set out to do. Why? A “perfect storm” in meteorology is when multiple weather patterns converge to...
by Jonathan Halder | Jul 10, 2025 | Blogging, MS Access
Right now I’ve got a lot going on. You may have noticed I have stopped writing daily posts. It’s been going on my todo list every day, but I just am feeling too drained by the end of the day and my brain just isn’t coming up with things to write very...
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...
