dynamic creation of pdf from vba

[jimatqsi]

Can someone please explain how to dynamically create a pdf from within Access? We've got Adobe Acrobat, which installs Adobe PDF print driver and also the Win2PDF print driver. How can I pass a filename to these print drivers so as to make a completely automated report to pdf? I don't want the dialogue box that asks what name the pdf should be given.

Thanks,
Jim

[PianoMan64]

Can someone please explain how to dynamically create a pdf from within Access? We've got Adobe Acrobat, which installs Adobe PDF print driver and also the Win2PDF print driver. How can I pass a filename to these print drivers so as to make a completely automated report to pdf? I don't want the dialogue box that asks what name the pdf should be given.

Thanks,
Jim

As far as I know Jim, don't know of any API options for the Win2PDF or the Adobe Distillar to pass Filename value to it.

One thing I did think about though is you could simply pass it the key strocks using the SendKeys Function within access, but that is no gaurantee that it's going to work...

Just a thought,

Joe P.