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

  1.
    yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   Ambassador 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
  2. 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
    1. 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
      1. 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
      2. 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
  3. Jennib370 Posted messages 54 Status Member 1
     
    It doesn't work, but thanks anyway :)
    0