Exporting to PDF

[Guest]

Through searching I believe I found that Access 2000 doesn't directly support exporting reports to PDF

My goal

Instead of previewing a report in access I would like the user to click a command button that would export a report into PDF. I have the full version of Acrobat 6.0. I want to bypass the step of having to use the PDF Writer and would perfer for as much as I can to happen programatically

My ultimate goal is to get the report exported into PDF and then be able to mail the report using our mail client (GroupWise or SMTP) worst case I could intall Outlook 2000 and have Outlook pull mail from GroupWise. When the mail client opens the created PDF will be attached to the email. Also I need the PDF saved in a file directory at a specified location..

Is this anything someone is familiar with or has any input. I would perfer to do as much of the programming myself and limit purchased 3rd party products for you use a lot of control.

Maybe one of the very helpful MVP's (which I thank for all there help in the past that they provided) has something like this on there site

Thanks Muc
Brian

 

[solex]

Brian,

There are two ways that I have used to accomplish what you want: (1) use
send keys, it is kludge and may have problems if the user is pressing some
keys during the code execution, but it works or (2) add a value to the
registry for the PDF writer called "PDFFilename" doing so will suppress the
save as dialog box. Both instances are predicated on the default printer
being set to the PDFWriter.

Regards,
Dan

Through searching I believe I found that Access 2000 doesn't directly

support exporting reports to PDF.

My goal:

Instead of previewing a report in access I would like the user to click a

command button that would export a report into PDF. I have the full version
of Acrobat 6.0. I want to bypass the step of having to use the PDF Writer
and would perfer for as much as I can to happen programatically.

My ultimate goal is to get the report exported into PDF and then be able

to mail the report using our mail client (GroupWise or SMTP) worst case I
could intall Outlook 2000 and have Outlook pull mail from GroupWise. When
the mail client opens the created PDF will be attached to the email. Also I
need the PDF saved in a file directory at a specified location...

Is this anything someone is familiar with or has any input. I would

perfer to do as much of the programming myself and limit purchased 3rd party
products for you use a lot of control.

Maybe one of the very helpful MVP's (which I thank for all there help in

the past that they provided) has something like this on there site.