ChefGroleau
asked on
Printing a Ms Access Report as a Postscript File
I want to be able to use VBA to print automatically Ms Access Report as Postscript Files, by giving the path and file name.
I tried the OutputTo function but there is no PS format.
Can anyone help me and tell me how to do it in Access
I have Microsoft Office XP SP-2, Acrobat Distiller 5.0.
Thank you
M-A
I tried the OutputTo function but there is no PS format.
Can anyone help me and tell me how to do it in Access
I have Microsoft Office XP SP-2, Acrobat Distiller 5.0.
Thank you
M-A
Hi ChefGroleau,
Download from the following link
www.almosawe.ae/jaffer/pdf-Report.zip
Read 2-PdfModules-Readme.txt to install,
part of the mdb ( the frmDemo) will print to PS,
I hope this helps.
jaffer
Download from the following link
www.almosawe.ae/jaffer/pdf-Report.zip
Read 2-PdfModules-Readme.txt to install,
part of the mdb ( the frmDemo) will print to PS,
I hope this helps.
jaffer
ASKER
Hi I'll raise the points to 1000 pts for the answer.
The problem I have is that I cannot install other applications ( ex Ghostscript, MakePDf etc.) on the users PC because of the limited rights assigned to all the users in the company. My Ms Access application will be distributed to about 20 persons, so I don't want to do some specific settings on all of them.
The only things I can use is Microsoft Office XP, Adobe Acrobat 5.0, Acrobat Distiller 5.0 and all of their APIs.
Their must be a way to output a PS with that. In Excel it's possible by doing this :
MySheet.Range("myRange").P rintOut copies:=1, preview:=False, _
ActivePrinter:="Acrobat Distiller", printtofile:=True, _
collate:=True, prtofilename:=PSFileName
But I need to do it for a Ms Access Report.
Thank you
The problem I have is that I cannot install other applications ( ex Ghostscript, MakePDf etc.) on the users PC because of the limited rights assigned to all the users in the company. My Ms Access application will be distributed to about 20 persons, so I don't want to do some specific settings on all of them.
The only things I can use is Microsoft Office XP, Adobe Acrobat 5.0, Acrobat Distiller 5.0 and all of their APIs.
Their must be a way to output a PS with that. In Excel it's possible by doing this :
MySheet.Range("myRange").P
ActivePrinter:="Acrobat Distiller", printtofile:=True, _
collate:=True, prtofilename:=PSFileName
But I need to do it for a Ms Access Report.
Thank you
Hi ChefGroleau
Any luck with your quest?
I found a site that might be of interest, but they convert to pdf too, take a look at it anyway,
http://ourworld.compuserve.com/homepages/attac-cg/
Good Luck,
jaffer
Any luck with your quest?
I found a site that might be of interest, but they convert to pdf too, take a look at it anyway,
http://ourworld.compuserve.com/homepages/attac-cg/
Good Luck,
jaffer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ChefGroleau
While thanking you for the points and grade,
Could you please tell me what did you decide to do, and how my comment helped you.
thanks
jaffer
While thanking you for the points and grade,
Could you please tell me what did you decide to do, and how my comment helped you.
thanks
jaffer
https://www.experts-exchange.com/questions/20559244/Output-report-to-Acrobat-Distiller.html
https://www.experts-exchange.com/questions/20647296/Access-and-distiller.html
https://www.experts-exchange.com/questions/20490200/Automating-Adobe-Distiller-Printing.html
and
https://www.experts-exchange.com/questions/20711112/Using-Acrobat-PDFWriter-Win2000.html
just to name a few.. plenty of info and examples for to get you done!
Good Luck!
Dave