I did not upload anything.
I downloaded your posted file.
Just do the edits.
I did not upload anything.
I downloaded your posted file.
Just do the edits.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Then I don't understand what you want.
The Print All button prints each project record to a single 1-page PDF.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The Print All Button Publish Save each Record, in Separate file Project Name + Project Number .PDF at C:\Reports. DONE.
Problem, instead of publishing inside the report only the respective record, publishes all.
Do not understand "Problem, instead of publishing inside the report only the respective record, publishes all."
I open the report directly from Navigation pane and each record shows on separate page because of the size of the Detail Section. Could set ForceNewPage property.
Why is this a problem? What do you want the report to do? If the code produces the appropriate output, why is the report setup a problem?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Create the Folder in C:\Reports, Click Print All, check one of the PDF Reports Published in C:\Reports
I've already done that several times. I get 5 PDF documents, each shows one project record.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I think you don't get it. open the file and scroll to the end
I did that. I view one PDF at 50%. The PDF is ONE PAGE and ONE RECORD. There is nowhere to scroll. These are the 3 lines of edited code:
DoCmd.OpenReport "Total Report", acViewPreview, , "ProjectNumber='" & !ProjectNumber & "'"
DoCmd.OutputTo acOutputReport, "Total Report", acFormatPDF, MyPath & MyFileName
DoCmd.Close acReport, "Total Report"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
you sure you clicking Print All? Delete all the Files in C:\Report, Click on Print All, Open a Report Pdf File
Yes, I am sure I click your Print All button. Done, Done, Done multiple times.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Sorry I missed this, works great, Big Thank you, let me try in Real thing and will buy you DinnerI did that. I view one PDF at 50%. The PDF is ONE PAGE and ONE RECORD. There is nowhere to scroll. These are the 3 lines of edited code:
DoCmd.OpenReport "Total Report", acViewPreview, , "ProjectNumber='" & !ProjectNumber & "'"
DoCmd.OutputTo acOutputReport, "Total Report", acFormatPDF, MyPath & MyFileName
DoCmd.Close acReport, "Total Report"
I may have edited that post to add the code lines after you first read it. Glad you got it working.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June sorry, I was doing and doing 10 things at the time, it works like a charm. some little problems but on DB File naming so nothing to do with this. Great HELP, and thank you for your patience and your Brilliant simple solution.