Access Report conversion to PDF

M

MSA

In my access db I have a report that I need the output to be converted to pdf
format. How can I go about getting a pdf output?

Thanks
MSA
 
R

Rick Brandt

MSA said:
In my access db I have a report that I need the output to be converted to pdf
format. How can I go about getting a pdf output?
Click to expand...

You have to acquire software capable of creating PDF files. Many of these are
free. Most work by acting as a virtual printer so once installed you can create
PDF files from any program capable of printing.
 
6

'69 Camaro

Hi.
How can I go about getting a pdf output?
Click to expand...

Make your PDF program, such as Acrobat Writer, the default printer and
"print" the report with the following line of code:

DoCmd.OpenReport "rptMyReport", acViewNormal

If you are using Access 2002 or higher, then you can use code to switch the
default printers. If you are using an earlier version, check out Albert
Kallal's switch printer code on the following Web page:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

If you don't already have Acrobat Writer installed, you could install a free
one, such as CutePDF, and print the report to it. Please see the following
Web page:

http://www.cutepdf.com/Products/CutePDF/writer.asp

It requries Ghost Writer (link found on that same Web page) and the printer
driver.

Other PDF writers to consider:

http://www.pdf995.com
http://www.primopdf.com
http://sourceforge.net/projects/pdfcreator

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
M

Mark Andrews

Our products might have some interest to you.

Mark
RPT Software
http://www.rptsoftware.com

PS: If you don't figure out your best solution send me an email (use the
support email from our site)
and I will help you out with possible solutions. Been selling our products
for about 6 years.
 
G

George Nicholson

Been selling our products for about 6 years.

lol, not with that link...

"Not authorized to view this page."

(following link prompts for username & password)
 
M

Mark Andrews

Our hosting company is going to get fired very soon if this is the case.
The site works fine from
here in Pittsburgh PA. We have not setup any security layers. Also we had
sales yesterday and the day before
so I thinking the problem is isolated.

If anyone notices this username/password popup please send me an email at
[email protected]

remove the ____NOSPAM____

Our hosting company did just change a few things around.
 
E

Ed Mana

I have Adobe Acrobat v7.0 installed. I used some code to select the correct
printer but am getting the dialog box to save the document. I would like to
specify the document name and path to save it before printing or duing
printing so I don't have this come up. This needs to run w/out any user
intervention.

Any Ideas?
TIA,
Ed
 
S

SA

MSA:

Our PDF and Mail Library for Access supports automatically outputting
reports from some of the most popular PDF drivers to files of your choosing,
with filters, bookmarks etc. Stop by our web and look in the developer
tools section.
 
Top