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 31, 2025 | MS Access, MS Access Queries, MS Access VBA Coding
Enjoy! ‘Creating a Passthrough query read only recordset on the fly in VBA ‘Put this in a normal module, call it from any other module ‘This is requiring DAO.Database and DAO.QueryDef objects so that ‘ the recordset will survive after the...
