access 2010 report - preview in popup window needs EXPORT button
Posted on 2013-01-28
I have a report that opens in print preview mode in a popup dialog box. It needs to have a button somewhere (either on report header or popup menu bar) that runs code to export report source to EXCEL. I also have code in the report in the report-Format event.
I have all the reports in the application opening in a popup window in preview mode, and the user can right-click to print.
I currently have the EXPORT command button on the report header and it works fine, except that the button doesn't show in preview mode. If I change the view to acViewReport, the button appears and works well, but the report_Format event hasn't run, so that code doesn't get executed. (it sets the heading and date text fields on header section). Also, I can't seem to change the size of the popup to fit the acViewReport so it doesn't look good.
Any ideas how I can have an EXPORT to EXCEL button or similar and still show report in preview mode in the popup window?