Hello All,
Another day another sticky VBA question!
I have an invoicing database in Access, that increments the invoice number each time a new invoice is entered which works fine. I want to be able to convert the Access report which is the invoice into a PDF file with the correct invoice number as part of the PDF file name. i.e. If I have created invoice number 210 in the database I want to produce a PDF with the filename invoice210.pdf. I have tried various products like Jaws PDF but being external to Access I can pass on the filename when I go to print it.
Anyone tried this before?
Thanks for any assistance