output to pdf

  • Thread starter Thread starter pmallick
  • Start date Start date
P

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
 
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
 
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.
 
Thankyou all so much, i downloaded it on the other computers and it works
beautifully.

Really appreciate you taking the time.

Pauline
 
Back
Top