Exporting a Form to html by a commandButton 2

[Programmer2006]

I am trying to export a form to html by a commandButton
using the TransferText method. Below is my code.

Private Sub cmdExport_Enter()
DoCmd.TransferText acExportHTML
End Sub

I get a compile error saying that I need to specify a table. I also wrote it as
DoCmd.TransferText acExportHTML,,, "MyFileName.HTML"
What exactly and how exactly should I write the parameters for this method?

 

[PHV]

Put the cursor inside the TransferText word in your code and press the F1 key.

Anyway this method operates with Table/query, not Form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Programmer2006]

If that only works for a table how what commands work for a form? And how do I write it?

 

[PHV]

And what about explaining clearly what you want to do ?
For me, exporting a form to html is something like generating a Data Access Page (.dap) ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yummy7]

I think you should use OutputTo method:

 

[PHV]

Well spotted yummy7 !
DoCmd.OutputTo acOutputForm, Me.Name, acFormatHTML, "MyFileName.HTML"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886