Printing in PDF

[Alain]

Hello to all,

Is it possible to print a selected form in a PDF format via a command object
(button), the reason is my client would like to start printing forms without
the financial fields, this forms have all the info he requires so no need
for a report to be build (original idea at desing time)
I am capable via some regular code to render some field invisible at print
time, which solve the financial problem but how to select the pdf machine at
the code level.

I do not have the actual Acrobat software to make pdf documents but have a
pdf machine that do the same job, is there a reference that need to be added
to modules ? if yes then which one is required

Thanks in advance

Alain

 

[Rick B]

First, you should not print a FORM, you should print a REPORT. The forms
are typically for entering, editing, and viewing data. I would create a
button on the form that, when clicked, would open or print a report for the
curent record.

Second, you can't do this in a PDF format. Microsoft has a funny feeling
about supporting Adobe's format

The Microsoft product is called Snapshot Viewer and is supported.

Hope that helps,

Rick B

 

[Ken Snell [MVP]]

If you have ACCESS 2002 or later version, *and* you have a PDF printer
driver installed on your PC, you can set the Application.Printer object to a
PDF printer device (print driver) before you print the report, and then set
it back to what it was before you changed it.

Check it out in Help -- post back if you have questions.

 

[Alain]

Thanks,
the db was desing like that by another programmer so....

the snapshot viewer, does it come with office or office tools or is it a
separate program, it is the first time I ear that name

Thanks

 

[Rick B]

It is free, and I think comes with Office. My IT department installed it on
all our PCs when we starting using Access a lot. I know it is free and the
recipient must have it to view any reports you send them in that format.
Might not be a good choice if you send these to folks outside your
organization.

Rick B

 

[User]

The folks at http://pdf.iteksoft.com/
have a reasonable price PDF printer that I have had good luck with.

 

[Alain]

Thanks Ken,

right now we have only Access 2000 but will be migrating to Access 2003 in
January.
Quick question:
If I develop some code in 2003 to be able to print in a PDF format and make
a convertion to 2000 for the users that still uses 2000, can the code still
works if the users have a PDF print driver or the users must convert to a
newer version of Access?

Thanks

Alain

 

[Ken Snell [MVP]]

No, any code that works in 2003 but won't work in 2000 will still not work
in 2000 if you convert a 2003 file to 2000.

Your users will need to upgrade to 2003 in order to be able to use the code
that works in 2003 but not in 2000.
--

Ken Snell
<MS ACCESS MVP>