Export Subform Result to Excel

[cassey14]

Hi everyone!

I really need your help..

I have a search form..And in that search form I have a subform..When they search, the results will display in the subform..I want to export to excel the result in the subform based on the query they search..

Thank you in advance

-cassey

[anukagni]

Yes its possible ..first i want to know the sub form which you have created is reflecting any query or by the table creating that sub - form any way u try the following code in that form...

1. in the desing view of the form ...creat a botton & in event tab in On Click Event write the following code

" On click_your button
Dim stdocname As String
stdocname = "your table or query name"
DoCmd.OutputTo acReport, stdocname "

[nico5038]

When you have a basic query for the subform and apply a filter, then that query's SQL can be combined with the filter to achieve what you need.

Need more info ?

Nic;o)

[cassey14]

Hi Thanx for all the replies..but appently I cant use do.cmd output to because the recordsource of my subform is query and asking for a parameter..

please explain to me further.. I really need all your help..

thank you in advance..

[nico5038]

Hmm, then it's best to remove the parameter from the query and add a textbox on your mainform for the needed value and a button to activate the filtering of the subform by the value from the textbox.
That will also allow the creation of a query for the export to excel.

Idea ?

Nic;o)

[cassey14]

I already have combo boxes and text boxes..I used stored procedure to search multiple fields because im using .adp access..the recordset of my subform is the stored procedure I created for searching..

[nico5038]

Hmm, I have no experience with .adp, but when you have a recordset behind the subform then you can use code and the RecordsetClone method to fill an excelsheet.
On the otherhand you could ofcourse also try to create a method for the stored procedure to redirect the found data to an excel sheet as DTS should have that possibility. Guess you'll need to ask a MS SQL expert how to do something like that.

Nic;o)

[nico5038]

Sorry, but I have no .adp experience yet.
Perhaps http://www.oreilly.com/catalog/accesscook2/ holds some good info.
When you follow the examples link you can download and check the sample databases for adp.

Nic;o)

[Limbersky]

Hi,
you should be able to export subform's content with use of Access add-in 'A2EE.mda' which is intended for exporting data from Access to Excel sheets.
You will download the add-in and see more details on:
limbersti.cz/A2EE/
BR
Norbert

[zmbd]

see if this helps
http://www.accessmonster.com/Uwe/For...bform-to-Excel

Search TransferSpreadsheet on this forum for info there.
You might start here:
http://bytes.com/topic/access/answer...to-rename-file
-z