This is a good solution (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27056617.html
) but I also need to know how to select the actual printer is is going to. I have tons of TIF files that I need to convert to PDF (thanks MSFT for dropping tif). I have purchased a printer driver from CutePDF that I use in my Access VBA code that will print anything to a PDF.
In Access VBA, I can set the printer to Auto PDF (it shows as an installed printer) then I can print an Access report to Auto PDF. I have tried the following with the API call with no luck: ShellExecute(Application.h
pp, "print /D:Auto PDF", WrkFileName, "", "", 0). I receive "Unable to initialize device Auto PDF" then I replace that with CPWPT185: (which is trhe port assigned to this print device) and I get the same error.
Is there a way to direct the API to a specific printer that is installed on the system?