Output to pdf using fields (1 Viewer)

[bobdydd]

Hi

I have a routine that outputs an MS Access report as a pdf file which works OK. It does not open the file which is what I want.
DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:\Users\JEFF1\Documents\rptTransactionInvoiceExcVAT.pdf", False

What I would like to do is output the pdf file with a Customer name and number from the field Me.txtAmazonBuyer. I have tried:
DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:\Users\JEFF1\Documents\" + ([Me.txtAmazonBuyer]) + ".pdf", False

But no joy. Can anyone help?
Thanks

 

[Mihail]

Use "&" instead "+"

 

[bobdydd]

Hi
I have tried that but it doesn't do it

Thanks anyway

 

[Mihail]

Sorry. I see that "+" and I don't read anything else.
1) If the statement accept to save as acFormatPDF then, as far as I know, is no need that you specify the extension.
2) txtAmazonBuyer seems to be a control ( a text box, I think) in your form. So, no need for brackets.

Try this:

DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF,  "C:\Users\JEFF1\Documents\" & Me.txtAmazonBuyer, False

 

[gerry@docshop.ie]

here is a line from my code but I have modified to your data, that outputs to a pdf and displays the PDF document, to stop display delete 'True' but leave the comma

DoCmd.OutputTo acOutputReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:\Users\JEFF1\Documents\" & Me.txtAmazonBuyer & ".pdf", True, , , acExportQualityPrint

 

[Mihail]

And ? Is this code working ?

 

[gerry@docshop.ie]

Yes this line runs on an 'On Click' event for a button on my customers form.

 

[bobdydd]

Thanks guys for all the prompt help. This is the line that did it for me.
DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:\Users\JEFF1\Documents\" & Me.txtAmazonBuyer & ".pdf", False