M
Mikey B
(I apologize for crossposting. I originally put this in Forms Coding before
I noticed an Import/Export section.)
I am using a continuous form to show a query. It has a form header with the
field names and a form footer with filter buttons and boxes for the user
input/select criteria to modify the list.
I have a command button with this code in it:
Private Sub Export_to_Excel_Macro_Click()
DoCmd.OutputTo acOutputForm, frmAlonza77List, acFormatXLS, , True
End Sub
This work well except that I would like it not to include the controls in
the Form Footer in the export to Excel.
Deleting the resulting 'Controls' columns off the excel sheet is easy
enough, but many people (Supervisor) using this feature are confused by the
excessive data and I am trying to make it as easy as possible for everyone.
Any help would be appreciated.
I noticed an Import/Export section.)
I am using a continuous form to show a query. It has a form header with the
field names and a form footer with filter buttons and boxes for the user
input/select criteria to modify the list.
I have a command button with this code in it:
Private Sub Export_to_Excel_Macro_Click()
DoCmd.OutputTo acOutputForm, frmAlonza77List, acFormatXLS, , True
End Sub
This work well except that I would like it not to include the controls in
the Form Footer in the export to Excel.
Deleting the resulting 'Controls' columns off the excel sheet is easy
enough, but many people (Supervisor) using this feature are confused by the
excessive data and I am trying to make it as easy as possible for everyone.
Any help would be appreciated.