Emulate Datasheet View For Ad-hoc SQL?

[MDW]

I'm making a form that will allow users to select certain fields from a table, enter criteria, etc, and then create a recordset (using ADO) that I will then export to Excel. However, they may want to "preview" what they just picked before putting it into Excel. Is there some control or some way to view an ADO recordset in some facsimile of datasheet view

 

[Chris Nebinger]

Create a temporary query, and then open it:


On Error Resume Next
DoCmd.DeleteObject acQuery, "Temp"
DAO.CreateQueryDef "Temp", "Select * from MsysObjects"
DoCmd.OpenQuery "temp"



Chris Nebinger

-----Original Message-----
I'm making a form that will allow users to select certain

fields from a table, enter criteria, etc, and then create
a recordset (using ADO) that I will then export to Excel.
However, they may want to "preview" what they just picked
before putting it into Excel. Is there some control or
some way to view an ADO recordset in some facsimile of
datasheet view?

 

[Duane Hookom]

You might want to review the DH Query By Form at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
MS Access MVP

I'm making a form that will allow users to select certain fields from a

table, enter criteria, etc, and then create a recordset (using ADO) that I
will then export to Excel. However, they may want to "preview" what they
just picked before putting it into Excel. Is there some control or some way
to view an ADO recordset in some facsimile of datasheet view?