Recent content by bsm2th
-
B
Saving report to pdf fails with error 2501 "The OutputTo action was canceled"
the application. After OpenReport makes a pretty report, OutputTo will turn that into a .pdf. The 2501 line will stop things if the report is empty. Bob <bsm2th@gmail.com>- bsm2th
- Post #6
- Forum: Modules & VBA
-
B
Saving report to pdf fails with error 2501 "The OutputTo action was canceled"
Does your report do anything dynamic while printing the data? If there is anything that looks at the data and changes the report because of it, this won't work. OutputTo just sprays data that is already there. OpenReport will allow where conditions to pick what data you want and it will allow...- bsm2th
- Post #5
- Forum: Modules & VBA
-
B
PDF output cancelled error 2501
Sounds like trouble with the filename. It works if you make it a simple text value. Try getting "B24crew_" & FileNamePartTwo & ".pdf" out of the OpenReport line. Put "Dim filename as String" at the beginning of the procedure, then filename="B24crew_" & FileNamePartTwo & ".pdf" before the... -
B
Where Condition and Output to PDF file
If the report has no results, I am getting a hundred page report. Openreport sees no records and throws an error 2501 which I catch and print a message box asking the user to make sure the month and year are correct. OutputTo on the other hand ignores the where conditions that openreport used...