Access Access variable string for export

Nov 28, 2017
Reaction score
I am trying to export a form to pdf for an active record and I want it to save the pdf with the tracking number. ( i.e, \\corpdata\Finance\Vendor Invoices\Temp\770579127745.pdf)

. "\\corpdata\Finance\VendorInvoices\temp\" & forms!FEDEX_Bill_forPDF_VendorBill![Shipment Tracking Number] & ".pdf" in output file in export with formatting in a macro gets: "dude you're a dumb @#$" (Microsoft Access can't save the output data to the file you've selected). I have rights (can add / delete / modify) and it is an empty folder so I am not creating a duplicate. I have been able to save to both the local drive and corpdata (lan) locations if I hard code the output file (like \\corpdata\Finance\Vendor Invoices\temp\123456.pdf ) . I have also tried "\\corpdata\Finance\Vendor Invoices\temp\" & forms![FEDEX_Bill_forPDF_VendorBill]![Shipment Tracking Number] & ".pdf"

Thank you for being a great resource.


  • upload_2017-11-28_12-13-7.png
    13.1 KB · Views: 124

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question