Add pdf to the toolbar


G

Guest

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

Advertisements

R

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.
 
G

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.
 
G

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()
 
Ad

Advertisements

S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PDF maker on toolbar in Access 1
how to suppress pdf toolbar in Word 2
Is Save As PDF Add-in installed 6
pdf 2
PDF 1
pdf 1
PDF 5
pdf 1

Top