Exporting PDF document with dynamic name and changing save destination

[AdrianoG87]

Hi all,

I have a form with a button I click to generate an invoice using a report I created. I export as a PDF and have to rename the file every time I create one. I've also got to save each invoice to a different folder as each of my customers has a separate folder dedicated to their invoices.

I am currently cool with generating each invoice individually as it allows for a final once over look of the data in the form before the document is generated.



Each invoice file name needs to consist of a Customer name, an Invoice Number a Year and Week number. Each invoice also needs to be saved to the customer's own folder.

For this, I currently have 2 tables, an invoice register which contains the name/invoicenumber/week/year and another table that has the customer's invoice folder location.

Using these 2 tables, I currently have a query that is able to generate the desired name for the file as well as display the the intended save destination. using this information, i need to be able to hit a button on my form that will export the report with the corresponding generated file name and save it to the intended destination.

i don't know any of that coding stuff and most of the googled results i have seen have been SQL or VB etc. if someone can provide me with that coding and an indication of what i need to substitute and where. that would be great.

thanks in advance

Adriano

[June7]

We can refer you to examples but you are going to have to learn VBA to customize for your needs. Here are two:
https://www.accessforums.net/import-...ges-25042.html
https://www.accessforums.net/access/...pdf-25574.html