how to output report in PDF then print it to printer?
thanks
how to output report in PDF then print it to printer?
thanks
Use DoCmd.OutputTo to create PDF.
Use DoCmd.OpenReport to send report to printer.
If you want to build filter with VBA and apply to WHERE argument, first DoCmd.OpenReport to screen with filter criteria, followed by
DoCmd.OutputTo ...
DoCmd.PrintOut ...
DoCmd.Close
Why do you need PDF?
To print an already existing PDF revew https://www.access-programmers.co.uk...f-file.287501/
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.