View original (French)

Create multiple PDFs from an Access report/state

Jennib370 Posted messages 54 Status Member -  
Jennib370 Posted messages 54 Status Member -
Hello,
I have a T_Personnel table with a field "ID" and a field "Votre nom" that I use to generate a report E_Certificat which lists 30 certificates (1 page per person but in the same report). I would like to print them as PDFs but separately. Is that possible?
Thank you!

3 answers

Answer 1 / 3
yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   Ambassadeur 1 588
 
Hello,
this seems possible to me, perhaps by opening the state in a loop, each time for a single person or a single certificate.
0
Answer 2 / 3
Jennib370 Posted messages 54 Status Member 1
 
Yes indeed, if I do it one by one, it works, but I was wondering if it’s possible in one step.
Thank you!
0
yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   1 588
 
"an step," I would code a loop in VBA.
I don't quite see, otherwise, how to print each page separately (to another PDF file).
0
Jennib370 Posted messages 54 Status Member 1 > yg_be Posted messages 23437 Registration date   Status Contributor Last intervention  
 
I found this, but since I’m not very good at VBA, lines 20-21-22 are in red so something isn’t working and I don’t know what...
0
yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   1 588 > Jennib370 Posted messages 54 Status Member
 
Obviously, a closing parenthesis is missing. I don’t know stringformat, I assume a closing parenthesis should be added at the end of line 22. Otherwise, perhaps: 
strFichierPDF = DossierSpecial(Bureau) & "TestInterlocuteur " _ & Format(rst("id"), "000") & " - " & rst ("Votre nom") & ".pdf"
0
Answer 3 / 3
Jennib370 Posted messages 54 Status Member 1
 
It doesn't work, but thanks anyway :)
0