Add pdf to the toolbar

[Guest]

The toolbar has the pdf option in Word and Excel but it does not appear in
access.

 

[Rick B]

What toolbar?

What version are you using?

You should post this as a "suggestion" if you wish to make a suggestion for
changing software.

 

[Guest]

Version 6.0. The toolbar in access. When you go to export, in my case a
jobsheet. My colleague has the option to send as a pdf and email. We have
since found out that he has adobe 7.0 and i have 6.0.

So i need to upgrade to 7.0.

Thanks though.

 

[Guest]

I think in Access you'd have to write a function which you'd call from a
custom toolbar button. You'd first need to install a PDF printer driver. I
use CutePDF Writer available free from:

http://www.cutepdf.com/

With this a suitable function would go like this:

Public Function PrintToPDF()

Const USERCANCELLED = 2501

Set Application.Printer = Application.Printers("CutePDF Writer")
On Error Resume Next
RunCommand acCmdPrint
If Err <> 0 Then
If Err = USERCANCELLED Then
' do nothing
Else
MsgBox Err.Description
End If
End If

' set printer back to windows default
Set Application.Printer = Nothing

End Function

Just paste the function into any standard module in the databse . Then set
the On Action property of the custom button to:

=PrintToPDF()

 

[Stephen Lebans]

There are some issues with allowing Adobe to install it's Toolbar in the
Access UI. Perhaps they will not affect you. Search GoogleGroups if you are
concerned.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.