Access Database to make parts orders, output to Excel.

[Guest]

I am trying to make my parts order database output the form to an Excel
spreadsheet and retain the layout, when I export Excel just gives a
spreadsheet with each field in a column. There is one address and a list of
up to 52 parts in two columns

 

[Guest]

You can't export a form. You could export a report but the layout will not
be kept either. What i would do is export the result of a query to a hidden
sheet the the Excel workbook. Create another sheet with tel lyout rquired
and link to the cells of the hidden sheet.

 

[Arvin Meyer [MVP]]

You can only print a form, save an image of it, or turn it into a report.
Exporting only exports data, not the form's definition. You can export the
definition of a form to a text file with code to:

Application.SaveAsText

and reload it back into a new form with:

Application.LoadFromText