From: Rondy on
Hi all...

In Access 2007, is there code I can use to access Acrobat menu functions?

I have a form button that used to change the user's printer to PDFWriter
(A2K, Acrobat 5.0), print the form, then reset user's printer to previous
default. This button was working fine in A'07 version as well (mod printer
name to Adobe PDF of course), but suddenly it isn't working anymore. Not
only is it not working, it's not even error-handling correctly--just prints
out a hard copy on user's default printer with no error message or any
indication of what went wrong.

I would rather reprogram the button to utilize the new built-in Acrobat
menus, since my button usually also spellchecks, changes document date, and
various other last-minute on-print-type functions in addition to creating a
PDF... but I can't seem to find any documentation!?!

Any help is appreciated... TIA.
From: Rondy on
(We are now using Acrobat 9.0, if that helps or matters...)


"Rondy" wrote:

> Hi all...
>
> In Access 2007, is there code I can use to access Acrobat menu functions?
>
> I have a form button that used to change the user's printer to PDFWriter
> (A2K, Acrobat 5.0), print the form, then reset user's printer to previous
> default. This button was working fine in A'07 version as well (mod printer
> name to Adobe PDF of course), but suddenly it isn't working anymore. Not
> only is it not working, it's not even error-handling correctly--just prints
> out a hard copy on user's default printer with no error message or any
> indication of what went wrong.
>
> I would rather reprogram the button to utilize the new built-in Acrobat
> menus, since my button usually also spellchecks, changes document date, and
> various other last-minute on-print-type functions in addition to creating a
> PDF... but I can't seem to find any documentation!?!
>
> Any help is appreciated... TIA.
From: Rondy on
Found the answer (use DoCmd.OutputTo... choose acFormatPDF... can even
specify complete file path/name if saving directory known... and this method
creates the PDF about 5 times faster than using built-in Acrobat options!).


"Rondy" wrote:

> Hi all...
>
> In Access 2007, is there code I can use to access Acrobat menu functions?
>
> I have a form button that used to change the user's printer to PDFWriter
> (A2K, Acrobat 5.0), print the form, then reset user's printer to previous
> default. This button was working fine in A'07 version as well (mod printer
> name to Adobe PDF of course), but suddenly it isn't working anymore. Not
> only is it not working, it's not even error-handling correctly--just prints
> out a hard copy on user's default printer with no error message or any
> indication of what went wrong.
>
> I would rather reprogram the button to utilize the new built-in Acrobat
> menus, since my button usually also spellchecks, changes document date, and
> various other last-minute on-print-type functions in addition to creating a
> PDF... but I can't seem to find any documentation!?!
>
> Any help is appreciated... TIA.