I have created a button on form to export a report and save report to specified file location, however, the file does not seem to be there after running the code. When I Manual export the file as XPS type it works great. What am I missing?
Private Sub cmdExportReq_Click()
On Error GoTo cmdExportReq_Click_Err
DoCmd.OutputTo acOutputReport, "rptRequirementMainQuestions", acFormatXPS, "Z:\Access Database Design\Requirement Documentation\RequirementMain.xps", True
I have tried for True and false to display the results. Neither seem to give me the correct results.