open pdf after printed

Song · Jul 13, 2006

I installed free cutepdf driver. when open report preview, i manually open
the print dialog box, select the cutepdf driver, click ok, type in pdf file
name and create pdf file. however, how to open the newly created pdf file
automatically in code? thanks.

Graham R Seach · Jul 13, 2006

Song,

Try feeding the PDF filename to this function:
http://www.pacificdb.com.au/MVP/Code/ExeFile.htm

Syntax: Call ExecuteFile(strFilename, "Open")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Song · Jul 13, 2006

Thank you for the info. However, I do not know the file name and folder the
user might save the pdf, how do supply strFileName?

thanks.

Graham R Seach · Jul 14, 2006

Song,

This code allows you to use the standard Windows FileOpen dialog to find a
file:
http://www.mvps.org/access/api/api0001.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------