pdf printing

[narago]

Dear all
I have to print reports on "pdf files".
Each file must have a specific name related to the content of the report
Something like this:
Walter_7890.pdf
Mary_3432.pdf
I have tried with primoPdf but file name must be given manually for each file.

My code:
For x = a To b
DoCmd.OpenReport "Report1", acViewPreview, "", "Prot=" & x&

nLastName = DLookup("[lastName]", "table1", "[Prot] =" & x&)
nNumber = DLookup("[number]", "table1", "[Prot] =" & x&)
nn = "xx" & nLastName & nNumber & ".pdf"

DoCmd.PrintOut
DoCmd.Close
Next x


Thank you for your help
:banghead:

 

[vbaInet]

Please perform an Advanced Search on the forum for this. We've answered this question many times.

 

[narago]

I couldn´t find any result related to pdf printing.
"Sorry - no matches. Please try some different terms"

All threads suggested refer to printing on real printers but none to print on files.

 

[sxschech]

What version of Access are you using?

 

[narago]

access 2003 and cant upgrade it

 

[vbaInet]

In that case you need Stephen Lebans report to pdf module:

http://www.lebans.com/reporttopdf.htm

 

[narago]

vbaInet:

I´ll try it.
Thank you for your help