Unanswered: Programatically print Access 2007 form with embedded Excel as PDF
I'm having trouble printing an Access 2007 form with an embedded Excel worksheet as PDF. I had no problem with it in Access 2003 using PDF995, but in 2007 it just prints black where the spreadsheet is. I've tried using Adobe Acrobat and get the same result. I've added the Microsoft PDF download and am able to print it correctly, but am not able to control print selection. The PrintOut method will let me print the selected record only, but it won't let me use the Access PDF download. The OutputTo method will let me use the Access PDF download, but it won't let me print the selected record only. I can manually print the selected record with the options in the Access PDF download. Any insight would be appreciated.