Recent content by duncanmcl

I tried the similar logic of Todd Benson...could not get it to work Name: Create PDF from MS Access Report ' ' Description:On a machine where the Ado ' be PDFWriter is installed, the current p ' rinter is swapped out with the PDFWriter ' and the PDF file is created. The origina '...

thanks for your reply. In Access 2003, using VBA, I filter a report, update the reports caption, and print using printout...this way the unique report name for PDF is set and populates the save as windows/adobe window....I have tried to use sendkeys to tab..tab and enter..ie save...then close...

I have code to print out to PDF, I'm able to force a unique file name and I'm sitting on the save to pdf Windows window. I'm tring to programatically tab..tab and enter to complete the save, then next in a loop. I have tried the sendkeys method without success. It seems control/focus has passed...