output to pdf

[pmallick]

Hello all,

I have a database that sends a report by email in pdf format automatically
by pressing a button.

My problem is that whilst this works perfectly on my computer, I get an
error "2282 - the format in which you are attempting to output the current
object is not available." on other users computers.
I have checked that all the computers have Adobe Reader 8.

I would be most greatful for any help on this one.

Following is the code i have behind the button

DoCmd.OpenReport "ActionItem", acViewPreview, "",
"[ActionID]=[Forms]![ActionItem]![ActionID]", acHidden
Dim sAddress1 As String
sAddress1 = DLookup("", "Users", "[ID]=Forms!ActionItem!AssignedTo ")
DoCmd.SendObject acReport, "ActionItem", "PDFFormat(*.pdf)", sAddress1, , ,
"Action Item " & [ActionID] & " - Jandakot Airport Holdings", "Please see the
attached Action Item - Number " & [ActionID] & " you have been assigned to
implement.", False, ""
Me!SentDate = Date
DoCmd.Close acReport, "ActionItem"
DoCmd.Close acForm, "ActionItem"
Beep
MsgBox "This Action Item has been sent to the nominated person.",
vbInformation, "Thankyou"

Thanks

 

[NevilleT]

Hi
I assume you are using 2007. Earlier versions of Access don't support PDF.
Stephen Lebans - www.lebans.com - has a solution but you need to install a
couple of DLLs on the earlier version. I just put them in the same directory
as the mde or mdb file.

Neville Turbit
www.projectperfect.com.au

 

[Albert D. Kallal]

The built in PDF ability is only part of the latest builds of office.

So, you have to

a) ensure that sp2 for office 2007 is installed,
or
b) install the PDF add-in. You can find it here:
http://www.microsoft.com/downloads/...3c-6d89-4f15-991b-63b07ba5f2e5&displaylang=en

 

[Arvin Meyer [MVP]]

Adobe reader cannot create a PDF. Using Access 2007, you will need to follow
Albert's suggestion for service packs. Earlier versions do not have built-in
PDF creators. You can use Stephen Lebans utility mentioned by Neville, or
you can use any other PDF creator as a printer.

 

[pmallick]

Thankyou all so much, i downloaded it on the other computers and it works
beautifully.

Really appreciate you taking the time.

Pauline