Hi Guys
the following works ish - but losses the embedded picture in the report heading ?
any solutions ? -(Its weird as I have this on another D/B and it seems to work there but not on the below ,,)
'###
Dim strFileName As String
Dim folderdestination As String
Dim strReport As String
If Me.FormFilter = 1 Then
strReport = "TravelH"
'strFileName = "Certificate" & " " & Me.QuoteNo
strFileName = "S:\xxxxxx\AaaaaaaaL\CLIENTS\52674" & "Certificate" & " " & Me.QuoteNo & ".pdf"
Pause (0.5)
DoCmd.OpenReport strReport, acViewPreview, , acHidden
Pause (2)
DoCmd.OutputTo acOutputReport, strReport, acFormatPDF, strFileName, False
DoCmd.Close acReport, strReport