PDF Button on Form

  • Thread starter Thread starter Greta
  • Start date Start date
G

Greta

You're right...I have no problem with a button that prints
a report (or form)...but to print it to pdf? I can get
the form up, file, print, then select pdf, save the thing,
go to e-mail, select it to send as an attachment...I just
want one button that will make it a pdf to e-mail without
making my users go through many steps.
What I'm doing is a weekly group of forms that have been
completed within a timeframe. That group has to be e-
mailed to my user's boss. Pdf is the best way to do it, I
just want to make it easy for data entry people.
Thanks,
Greta
-----Original Message-----
In the case of word, or Excel, it does not "just convert", but in fact does
the same thing as if you hit print, and then selected the pdf driver.

So, really, I would assume you are asking how to print, or send a report to
the pdf file. In the case of ms-access, you are much more wide open as to
"what" you want to do.

However, the solution is to simply print the report you make to the pdf
printer driver.

While it seems you have the Adobe Distiller, there is also a number of free
pdf drivers on the net now.

So, perhaps your *real* question is how to make a button that prints a
report?


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn


.
Click to expand...
..
 
Ok, I kind figured that is what you want.

I guess the solution is to:

switch to the pdf printer
print report
switch back to users default printer.

For forms, I would not try and print them, but would make a report that
looks very similar (or perhaps even better/more clear) then the form. Forms
are for data entry, and you can run into a LOT of problems when you try and
print them.

If you are using access2002 or later, then the printer switch control
feature is available in code. If you use a earlier version of ms-access, you
can either:

1) save the printer selection with the report (this works well if you
only have ONE user of your application).
2) Grab my printer switch code AT:.

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

So, depending on what version of ms-access, you do have several choices.

Up to this point, your users will still have to enter a file name. If you
are using adobe distiller to create the pdf files, then you can actually set
the file name also. Thus, the ideal would be a one button print to pdf, and
then attached the file to a email. You would have to assume Outlook and NOT
Outlook express to do this however.
 
Back
Top