Export data in suborm with datasheet view

[Eddy]

Dear all,

I have a Main form and a subform, where the subform is in datasheet view.

I want to export the data in subform to Excel after setting the criteria in
Main form and adjusting the format in subform (reorder, hide and resize the
columns).

If I open the subform alone (not in Main form), then I can use the Export
command to export the data to Excel. But, I cannot do it when it is a subform
in Main form. OutputTo command cannot export the new format of the subform.

Please help!!

Eddy

 

[Klatuu]

Does it not work when you use the name of the subform in the outputto? Be
sure you are using the fully qualified name [forms]![frmMain]![frmSub] or
something like that. Another method would be to build a query that would
duplicate the data in your sub form and use the TransferSpreadsheet method.

 

[Eddy]

No...even I use OutputTo with the subform, it cannot generate the Excel with
update RecordSource and the new format.
I also build the query and then use TransferSpreadsheet method, but the
format of the subform (set by user, may be reorder or hide columns) cannot
display on the query.

Any other method?

Does it not work when you use the name of the subform in the outputto? Be
sure you are using the fully qualified name [forms]![frmMain]![frmSub] or
something like that. Another method would be to build a query that would
duplicate the data in your sub form and use the TransferSpreadsheet method.

Dear all,

I have a Main form and a subform, where the subform is in datasheet view.

I want to export the data in subform to Excel after setting the criteria in
Main form and adjusting the format in subform (reorder, hide and resize the
columns).

If I open the subform alone (not in Main form), then I can use the Export
command to export the data to Excel. But, I cannot do it when it is a subform
in Main form. OutputTo command cannot export the new format of the subform.

Please help!!

Eddy