L
Laurie Lawrence
We have recently upgraded to Windows XP and Access 2000
Things that once were have ceased to be
Our Access reporting is made up of several individual
reports. We cannot output them to PDF writer because each
report will have a separate pdf file and we want just one.
So we set our printer to Distiller to FILE and when we
print each report it prompts us for a postscript filename
(e.g. 1.ps 2.ps etc) and then at the end Distiller will
combine them all in a single PDF file.
With previous versions of Windows, the .ps files defaulted
to the default Access folder (Tools-Options-General). But
now, unless you re-apply the default folder each time you
want to produce pdf output, the .ps files seem to go to
random places.
So my questions are:
1) Can you automatically assign the output file name in
VBA so users don't have to enter it
2) How do I prevent Access from forgetting its default
folder?
We are using Adobe 5.
Things that once were have ceased to be
Our Access reporting is made up of several individual
reports. We cannot output them to PDF writer because each
report will have a separate pdf file and we want just one.
So we set our printer to Distiller to FILE and when we
print each report it prompts us for a postscript filename
(e.g. 1.ps 2.ps etc) and then at the end Distiller will
combine them all in a single PDF file.
With previous versions of Windows, the .ps files defaulted
to the default Access folder (Tools-Options-General). But
now, unless you re-apply the default folder each time you
want to produce pdf output, the .ps files seem to go to
random places.
So my questions are:
1) Can you automatically assign the output file name in
VBA so users don't have to enter it
2) How do I prevent Access from forgetting its default
folder?
We are using Adobe 5.