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:...
by Jonathan Halder | Feb 5, 2025 | Blogging, MS Access, MS Access VBA Coding
I found myself in a position where I needed to be able to take an arbitrary string and remove consecutive spaces in a string, replacing them with one space each. Example:”7122A05 N62A N656″to: “7122A05 N62A N656″ This is a pretty simple problem...
by Jonathan Halder | Feb 3, 2025 | Blogging, MS Access, MS Access VBA Coding
This is a very simple pattern. It simply is an object that does a command. It is defined by an Interface with a run() method like this: ‘Class Module Command ‘ To be used to Implement as an interface Option Explicit Public Sub run() End Sub An interface...
by Jonathan Halder | Jan 30, 2025 | Blogging, MS Access, MS Access VBA Coding
So this is my latest nested error test code. You can put it in any public code module and run MainProcedure to see what it will do. The thing to do here is to see how Access will behave in various scenarios and the code paths that execute and the ones that...
