Exporting of report or form to Excel

[jamz]

Hi everyone!



Hope someone can help me with this. and Thank you in advance.

Is it possible to export my data below exactly the same format with my access report or form to Excel?



And why is that whenever I print the above report, there is always cover page or first page that is unnecessary (Header). Where or what is the error? Thank you.

[ranman256]

Yes ,with a LOT of programming.
or
you can export to a PDF with a single line of code:
form.print, or docmd.output.

[jamz]

Hi ranman526 thank you for the reply. i have follow-up question,

And why is that whenever I print the above report, there is always cover page or first page that is unnecessary (Header). Where or what is the error? Thank you.

[CJ_London]

access doesn't do cover pages without a lot of additional work, so suspect you have a page break control in your report header. Otherwise it might be something to do with your printer settings or perhaps you have some code in one of the report opening events to generate a page feed.

Another possible reason is your report has become corrupted, in which case try compact and repair, and if this does not work, recreate your report