Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

adding a pdf extension to a report

Status
Not open for further replies.

BubbaJean

IS-IT--Management
Jun 5, 2002
111
0
0
US
below is code that PHV wrote and it works great, however my users want to add a another feature, save the report as a pdf file, as it stands when the user run this fuction it ask them to select a format MS Excel...HTML ...RTF Snapshot etc.. is there a way to set the report with the pdf extension?? I'm working in Access 2000 and I do have Adobe Acrobat PDFWriter

Thanks in advance...
PHV code

Private Sub cmdEmailNew_Click()
On Error GoTo Err_cmdEmailNew_Click

'opens an e-mail with the address in a form field

DoCmd.SendObject acReport, "rptRFQResponseLetter", , [Forms]![frmCustomerRFQ]![txtEmail], , , [Forms]![frmCustomerRFQ]![txtCustNo]
Exit_cmdEmailNew_Click:
Exit Sub

Err_cmdEmailNew_Click:
MsgBox Err.Description
Resume Exit_cmdEmailNew_Click

End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top