How do I change a report to excel

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

Guest

In my form I have created a commnand button to preview a report but instead
of being in a document form how would I change it to be viewed in Excel for
Run time access users.
 
Arlene

I'm not sure I'm following...

When I create and preview a report using Access, I see an Access report. I
can export that report to Word or Excel, but it isn't "in" either of those
UNTIL I export it.

More info, please...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Jeff,

Thanks for replying to me, What I was trying to do was I have created a Form
and within that form I have text boxes and Combo boxes. I have created a
Command button to view the report from a query but is there is a way to view
the report in a excel format instead of an access report. Here is a code I
have found on the web but not sure how to apply it.
DoCmd.OutputTo acOutputForm, "subfrm_ASSIGNED_DEFAULTS", _
acFormatXLS, "6000003_TARGET_DATA_ALL.XLS", True
 
You could use the TransferSpreadsheet to export your query directly to Excel,
then use the Shell command to open the workbook you just created.
 
Back
Top