Jim - can you manually export as in open report in preview and export using the ribbon?
Regards,
Bill Mosca
------ Original message------
From: Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]
Date: Mon, Oct 9, 2017 10:27 AM
To: luvmymelody@yahoo.com [MS_Access_Professionals];
Cc:
Subject:Re: [MS_AccessPros] Export as Excel question
I am back in the office today. was there any responses on this issue?
Thank You
Jim Wagner
On Wednesday, October 4, 2017 04:27:29 PM, luvmymelody@yahoo.com [MS_Access_Professionals] > wrote:
Hello all,
I have a report that the users now want to export a report as an excel file. I changed it to acformatXLS(*xls)* and it crashes. with an error of the format in which you are attempting to output the current object is not available. Windows 7 and Office 2016. Can someone please tell me the correct syntax for exporting to excel?
Thank You
Jim Wagner
DoCmd.OutputTo acOutputReport, "Rpt_TrainingRecordsReview", "acFormatXLS(*.xls)", myFileName, False, "", 0 ', acExportQualityPrint
'second report
DoCmd.OutputTo acOutputReport, "rptTrainingRecordsByDirector_Crosstab", "acFormatXLS(*.xls)", myFileName2, False, "", 0 ', acExportQualityPrint
__._,_.___
Posted by: wrmosca <wrmosca@comcast.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar