acFormatXLS not working

[Callahan]

With Access 2010, has anyone ever tried to export a form to Excel using


a VB command like:

DoCmd.OutputTo acForm, My.[FrmNam], acFormatXLS, xlsnam, False, "", -1

My result is a spreadsheet with field names, but no data. Wonder what the funny fix will be. Could be like the one I found for a problem sending form filters to a report. The solution (found by accident) was to close the report before opening it. That's closing an unopened report. Funny, but it works.

[rpeare]

to my knowledge you can't export a form, you can export the contents that the form is displaying though, just reference the query driving the form as the source for the export.

[Callahan]

Yes you can export the contents of a form, and that's what I'm trying to do. It worked with good ol Access 2003.

[rpeare]

I think that's exactly what I said, exporting the contents, not the form itself.

[Callahan]

Yes, that is exactly what I'm trying to do. Go ahead, open a form, then right click on it's name in the object window and export it to Excel, you get a better looking spreadsheet from a form than you do from a query. Queries are not the answer to ever thang. I need to know why the heck the acFormatXLS is not working!!

[June7]

This worked, in button click on form to export:
DoCmd.OutputTo acOutputForm, Me.Name, acFormatXLS, "C:\Test1.xls", False, "", -1

It only exports data from bound controls.

[Callahan]

Well, maybe you are correct, that queries are the ticket. I changed my DoCmd to use the query that the form uses, and by the buh-boogidy-wuh-woogidy, it worked.

Funny!!! Thanks again rpearle