Dialouge box pops up while savinf access report as pdf file

[Guest]

Hello,
I have a VBA code which used to store more than 100 Access reoprts as pdf
file . Location to store the file is defined in the code.Recently It statred
asking for the location (dialogbox for saveas) to store the pdf file.
Interestingly it is not asking the same (dialog box)for one of the user.I am
using Acrobat writer 5.0, Adobe distller. Does anyone know how to fix this
problem?
Thanks
Srabani

 

[Warren]

Hi,

In my situation with Access 2000 and Adobe 7.0 I found the the solution
was in the registry. Although we are using different software, I say
this because i also had users who experienced different outcomes.

I my case,

HKEY_CURRENT_USER\Printers\DevModePerUser\Adobe PDF

is value that must exist in the registry if the user is not going to be
asked for a SAVE AS.

In my case, this setting did not exist in a users configuration until
they made a change to any setting of their Adobe PDF Printer settings.
So, to fix my problem, I would go to each user's terminal, right-click
the Adobe PDF printer > Printing Prefences, then unchek one of the
boxes, click Apply, then re-check the setting i unchecked.

This then created the abovementioned registry value and we all lived
happily ever after!

I hope this can help your situation.


Warren