Replaces the source data query with a query to an existing data source. The INSERT, SELECT FROM PREDICTION JOIN, and SELECT FROM NATURAL PREDICTION JOIN statements support **OPENQUERY**. A data source ...

Recorded on October 21, 2020. OpenQuery uses open-sourced datasets to solve technical challenges by using technology that has been around for a while and build on top of it. Get an inside look at what ...

Use the **SetParameter** method to create a parameter for use by the **[BrowseTo](Access.DoCmd.BrowseTo.md)**, **[OpenForm](Access.DoCmd.OpenForm.md)**, **[OpenQuery ...

I can't seem to work this out. SELECT * FROM OpenQuery(LinkedServer,' SELECT * FROM tblData WHERE SomeField LIKE ''' @SearchParm ''' ') But that doesn't seem to work. I have it working just fine ...

AFAIK the DoCmd.RunSQL is only used for "action" queries such as append, delete, etc. To achieve what you want, you'll need to create a new recordset based on your SQL statement.