Excel export from report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a database that had a button on our reports to export the report to
Excel. This button has disappeared and the person who uses the report has no
idea when that happened. Is this a toolbar that has been turned off or is it
something more involved.

We can turn the desired toolbar on when we open Access, but it goes away
when we open this particular database. I appreciate any help anyone can give.
 
One way to export to Excel is when you are in Preview mode, you have a button
on your toolbar ("Print Preview" is the toolbar name) that either "publishes"
the report in Word or "analyzes" in Excel.

You can also create a command button that would export the specified or
selected report directly into Excel with the VBA code of
DoCmd.TransferSpreadsheet (assuming you are using Access 03).
 
Back
Top