asked on Trying to send a report in PDF format to an established folder on computer
I am trying to send a report in PDF format to an established folder on computer. The folder path is
strClientAppealsAttachment
which I know is a real path because I debug.print it.
I really don't want to preview the report, just send it to the folder.
Here is my code:
but I get an The OutputTo action was cancelled and the report preview but I don't want it to.
????
strClientAppealsAttachment
which I know is a real path because I debug.print it.
I really don't want to preview the report, just send it to the folder.
Here is my code:
DoCmd.OpenReport "rptBillOfLading", acViewPreview, , , acHidden
DoCmd.OutputTo acOutputReport, "rptBillOfLading", acFormatPDF, strClientAppealsAttachmentFolderDataPath
but I get an The OutputTo action was cancelled and the report preview but I don't want it to.
????
Microsoft Access
Last Comment
SteveL13
ASKER
I do have full rights. And please remember, I don't want to preview the report. Just copy it to the directory.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Got it. I had to change this:
strClientAppealsAttachment
to this:
strClientAppealsAttachment
strClientAppealsAttachment
to this:
strClientAppealsAttachment
try first using FileCopy method to that location, see what happens.