Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
COURSE of the MONTH
8 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Automatic (VBA) creation of Adobe PDF (v.6) from MS Access (2003) report.
Posted on 2004-08-02
I have pursued and tried to understand the various “fragmented” solutions, advice and work a-rounds currently on file, but none provide a clear “Step by Step” coding solution for my problem which is:
A solution using MS Access (2003) Forms, Reports and VBA code etc. that will enable a User to open a "Print report" form dialog box with a “Print, save and email” option that will Automatically, background print the selected report directly to Adobe Acrobat Writer .pdf (V.6) and which will automatically (without any further user input) create (if new) and or save the pdf document using information (Drive Name, Path, Folder Name and File Name) pulled from a reference table with the current MS access database.
A solution using MS Access (2003) Forms, Reports and VBA code etc. that will enable a User to open a "Print report" form dialog box with a “Print, save and email” option that will Automatically, background print the selected report directly to Adobe Acrobat Writer .pdf (V.6) and which will automatically (without any further user input) create (if new) and or save the pdf document using information (Drive Name, Path, Folder Name and File Name) pulled from a reference table with the current MS access database.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
6
4
3- +2
16 Comments
Try my example on
www.almosawe.ae/jaffer/pdf-Report.zip
Which includes everything you will require.
jaffer
www.almosawe.ae/jaffer/pdf-Report.zip
Which includes everything you will require.
jaffer
Thanks for the quick response.
Is there any way to do it without using "Ghostscript" and "Makepdf"? I would prefer to solve the problem using only MS Access 2003 and Adobe Acrobat Reader V6.
Also the finished product will be part of a MS app that we will be run on 10-20 networked machines and the extra time and administration overhead to install "Ghostscript" and "Makepdf" etc. on all computers, isn't desirable.
Jeromy
Is there any way to do it without using "Ghostscript" and "Makepdf"? I would prefer to solve the problem using only MS Access 2003 and Adobe Acrobat Reader V6.
Also the finished product will be part of a MS app that we will be run on 10-20 networked machines and the extra time and administration overhead to install "Ghostscript" and "Makepdf" etc. on all computers, isn't desirable.
Jeromy
Jeromy
From what I read, there is no direct way with Adobe Acrobat Reader, thats when I found this solution and modified it and made to the public.
I think the only way to do with Adobe Acrobat Reader, is, when the save as dialog popup, you can use Sendkey commands to fill the dialogs automatically, but it is not adviseble, especially with muliti users.
You still have to install Adobe Acrobat Reader on every PC, Right?
You don't need Makepdf, its just an interface if you want to use Ghostscript directly, so you only need to install Ghostscript.
Besides, try to put Ghostscript on the server and point to it in the code, as the code needs the exact path of Ghostscript anyhow.
jaffer
From what I read, there is no direct way with Adobe Acrobat Reader, thats when I found this solution and modified it and made to the public.
I think the only way to do with Adobe Acrobat Reader, is, when the save as dialog popup, you can use Sendkey commands to fill the dialogs automatically, but it is not adviseble, especially with muliti users.
You still have to install Adobe Acrobat Reader on every PC, Right?
You don't need Makepdf, its just an interface if you want to use Ghostscript directly, so you only need to install Ghostscript.
Besides, try to put Ghostscript on the server and point to it in the code, as the code needs the exact path of Ghostscript anyhow.
jaffer
Dear Jaffer,
Thanks once again for the quick reply. Your suggestions are well taken and failing the availability of any other solution, I will probably implement your solution.
Just as a side note I mis-typed when I said "Adobe Acrobat Reader" I meant the full version of "Adobe Acrobat Writer" (and distiller if needed)
If I have the AA Writer v6 SDK, would that help?
Being inherently lazy, I’m trying to cut out as much configuration/Administrato
Cheers
Jeromy (A Kiwi, living in Thailand)
Thanks once again for the quick reply. Your suggestions are well taken and failing the availability of any other solution, I will probably implement your solution.
Just as a side note I mis-typed when I said "Adobe Acrobat Reader" I meant the full version of "Adobe Acrobat Writer" (and distiller if needed)
If I have the AA Writer v6 SDK, would that help?
Being inherently lazy, I’m trying to cut out as much configuration/Administrato
Cheers
Jeromy (A Kiwi, living in Thailand)
Hi
I had a similar problem and my work around involved a piece of software called pdf995. I was able to output the access report to pdf reliably and the pdf995 printer can be set up as a network printer.
I know it is not want you want but it gets aroud all the problems you mentioned
Cheers Steve
A kiwi living in NZ
I had a similar problem and my work around involved a piece of software called pdf995. I was able to output the access report to pdf reliably and the pdf995 printer can be set up as a network printer.
I know it is not want you want but it gets aroud all the problems you mentioned
Cheers Steve
A kiwi living in NZ
Steve,
1. Can you provide implimentation details?
2. Location of the "pdf995" site.
3. Any problems encountered?
4. Have you looked at Jaffers solution?
Jeromy
(Born in Ashburton, schooled in Christchurch, in Thailand since late 70's)
1. Can you provide implimentation details?
2. Location of the "pdf995" site.
3. Any problems encountered?
4. Have you looked at Jaffers solution?
Jeromy
(Born in Ashburton, schooled in Christchurch, in Thailand since late 70's)
Implementation is pretty straight forward go and look at www.pdf995.com is the site and they have a free version
try it see how it goes - you may need to check their developers FAQ
The one problem I encountered was that my code was faster than the printer - so I had program a delay into the code.
I have not looked at jaffer's solution
Cheers
Steve
try it see how it goes - you may need to check their developers FAQ
The one problem I encountered was that my code was faster than the printer - so I had program a delay into the code.
I have not looked at jaffer's solution
Cheers
Steve
Hi,
Just want to warn you : dont use pdf995 on a terminal server (win2000 TS). Even if the company says it works fine, there are a lot of problems.
Fred
Just want to warn you : dont use pdf995 on a terminal server (win2000 TS). Even if the company says it works fine, there are a lot of problems.
Fred
Dear Jaffer,
Have been able to get your solution working OK. Is there any way to save the resultant .pdf in colour instead of B&W? I checked the postscript settings and colour isn't an option.
Jeromy
Have been able to get your solution working OK. Is there any way to save the resultant .pdf in colour instead of B&W? I checked the postscript settings and colour isn't an option.
Jeromy
Jeromy
I am glad its working for you,
Color and Resolution (dpi) depends on the postscript printer you choose,
so, Yes color is an option.
jaffer
I am glad its working for you,
Color and Resolution (dpi) depends on the postscript printer you choose,
so, Yes color is an option.
jaffer
Active today
You may wish to study FreePDF:
http://freepdfxp.de/fpxp.htm
It is totally free and uses Ghostscript and the Apple Postscript driver which is capable of handling colour.
Be sure to download the "Administration Manual" as well as the sources (some basic code samples) and perhaps even the multidocument option.
/gustav
http://freepdfxp.de/fpxp.htm
It is totally free and uses Ghostscript and the Apple Postscript driver which is capable of handling colour.
Be sure to download the "Administration Manual" as well as the sources (some basic code samples) and perhaps even the multidocument option.
/gustav
Solution from Jaffer is working OK, so am sticking with that. Consequently didn't really check yours out.
Still would prefer a direct native adobe/Access solution, but "You can't always get what you want, but I try"
7DUD
Still would prefer a direct native adobe/Access solution, but "You can't always get what you want, but I try"
7DUD
Hi 7DUD
Could you please press on accept button next to the answer that solved your problem and close the question,
thanks,
jaffer
Could you please press on accept button next to the answer that solved your problem and close the question,
thanks,
jaffer
Featured Post
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
- Microsoft Applications
- Windows OS
- Fonts Typography
- Web Browsers
- Microsoft Word
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month8 days, 7 hours left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.