Printing in PDF

  • Thread starter Thread starter Alain
  • Start date Start date
A

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
 
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
 
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.
 
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
 
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
 
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
 
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>
 
Back
Top