Report presentation

[Dinesh]

Is there a way you can save an Access report as a .pdf
or .rpt file? Your help is greatly appreciated.

Regards,

Dinesh.

 

[jmonty]

A wise professor of mine once told me:
You don't have to know all the answers, but you do have to
know where to look them up.
Look here:
http://www.mvps.org/access/reports/rpt0011.htm

 

[Dinesh]

YOU ARE THE MAN!!! Thanks for your help!

-----Original Message-----
A wise professor of mine once told me:
You don't have to know all the answers, but you do have to
know where to look them up.
Look here:
http://www.mvps.org/access/reports/rpt0011.htm

.

 

[M Skabialka]

Having been told that the users had Adobe on their machines already I was
able to adapt the code on this site and it worked like a champ using Adobe
PDFWriter. Now I find out they all have Adobe Distiller, not Adobe
PDFWriter. I tried changing all instances in the code from PDFWriter to
Distiller but now it asks for a file name and location for each report, when
I am running a series in a batch, and there should be no user prompt at all.
In fact I am trying to run this from a command line, which works great on my
PC of course, but not on theirs.

Can anyone suggest what changes I need in the code on this web-site which
will make my batch run using Distiller rather than PDFWriter?

The code I think has to change is:

strOldDefault = QueryKey("Software\Microsoft\Windows
NT\CurrentVersion\Windows", "Device")
SetKeyValue "Software\Microsoft\Windows NT\CurrentVersion\Windows",
"Device", "Acrobat PDFWriter", REG_SZ
SetKeyValue "Software\Adobe\Acrobat PDFWriter", "PDFFilename", strPath,
REG_SZ
SetKeyValue "Software\Adobe\Acrobat PDFWriter", "bExecViewer", 0, REG_SZ

(Print report here)

SetKeyValue "Software\Microsoft\Windows NT\CurrentVersion\Windows",
"Device", strOldDefault, REG_SZ

Thanks,
Mich

 

[SA]

M:

That code will not support Distiller or the Adobe PDF driver of version 6;
those driver's simply have no registry entries available to set the output
file name. If you want to support those drivers (as well as many others,)
take a look at our PDF and Mail Library for Access, which supports the
Distiller and Adobe PDF drivers. You'll find it on our web.