What Do You Use Instead of DoCmd.OpenQuery or DoCmd.RunSQL

[Mr. JYC]

Hello,

What do you use to open a query that is stored within a string variable in
datasheet view? Is recordsets the only way? I just want to open it in
datasheet like a query that was just designed in design view.

It seems that DoCmd.OpenQuery uses a stored query and DoCmd.RunSql just runs
action queries.

Could someone help?

 

[Douglas J. Steele]

You could create a query and open it:

Dim dbCurr As DAO.Database
Dim qdfCurr As DAO.QueryDef
Dim strSQL As String

strSQL = "SELECT * FROM Groups"
Set dbCurr = CurrentDb()
Set qdfCurr = dbCurr.CreateQueryDef("temp", strSQL)
DoCmd.OpenQuery "temp"
dbCurr.QueryDefs.Delete "temp"
Set dbCurr = Nothing

 

[Mr. JYC]

Thank you Douglas!
--
Thank you for your help!
JYC

You could create a query and open it:

Dim dbCurr As DAO.Database
Dim qdfCurr As DAO.QueryDef
Dim strSQL As String

strSQL = "SELECT * FROM Groups"
Set dbCurr = CurrentDb()
Set qdfCurr = dbCurr.CreateQueryDef("temp", strSQL)
DoCmd.OpenQuery "temp"
dbCurr.QueryDefs.Delete "temp"
Set dbCurr = Nothing