1,512 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 40%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi GregFinzer,
Can't tell what is wrong.
"reportName" and "exportFilePath"....are these variables declared?
It's better that you show us your full code.
DoCmd.OutputTo, DoCmd.TransferSpreadsheet, and DoCmd.TransferText fails in Access 2016
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 23%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGF%3C/text%3E%3C/svg%3E)
Greg Finzer
21
Reputation points
I am running several commands as part of my Access application, none of them work now in Access 2016. It locks up access and never responds.
DoCmd.OutputTo acOutputReport, reportName, acFormatRTF, exportFilePath
Call DoCmd.TransferSpreadsheet(acExport, acSpreadsheetTypeExcel9, queryName, exportFilePath, True)
DoCmd.OutputTo acOutputReport, reportName, acFormatHTML, exportFilePath, 0
DoCmd.OutputTo acOutputReport, reportName, acFormatHTML, exportFilePath, 0
Call DoCmd.TransferText(acExportDelim, "", TableName, path, True)