Emulate Datasheet View For Ad-hoc SQL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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?
 
You might want to review the DH Query By Form at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
MS Access MVP


MDW said:
I'm making a form that will allow users to select certain fields from a
Click to expand...
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?
 
Back
Top