output report object directly to pdf file without any preview

[GraeagleBill]

I'd like the report object to output directly to the pdf file without any preview. The format property of the report is "Report View". Do I simply have the arguments wrong? (The two variables are valid string)

DoCmd.OutputTo acOutputReport, rptName, acFormatPDF, strCurPDFName

[June7]

Syntax looks fine.

So is the output failing?

[GraeagleBill]

The preview is fine and so is the pdf. What I'm trying to do is create the pdf WITHOUT first seeing the report preview. I.e., just write the pdf and nothing else.

[June7]

Did you try? It should work, however, any filtering supplied through OpenReport command will not be possible.

[Welshgasman]

https://codekabinett.com/rdumps.php?...docmd-outputto

[GraeagleBill]

Got it. Below is the open code and a pretty clear source of the problem. I can solve this problem either with a bit of code to update the query def or follow Welshgasman's suggestion, which I'll try first and report back after dinner

Private Sub Report_Open(Cancel As Integer)


If Left(strCurRetreat, 1) = "S" Then
    Me.Filter = "SPRING Like  ""*-*"" AND SUPPS = False"
    Me.FilterOn = True
Else
    Me.Filter = "FALL Like  ""*-*"" AND SUPPF = False"
    Me.FilterOn = True
End If


End Sub

[GraeagleBill]

Works like a champ! I'll finish up with some error handling and a boat-load of comments so that "I" don't forget what the whole scheme is about....

Private Sub pdfDirect(rptName As String, CtrlName As String)


strpdfFile = Forms("frmDocuments").Controls(Replace(CtrlName, "lbl", "tb"))
strCurPDFName = strCurRptsPath & "\" & strCurRetreat & "\" & strpdfFile & ".pdf"


DoCmd.OpenReport rptName, acViewPreview, , , acHidden
DoCmd.OutputTo acOutputReport, rptName, acFormatPDF, strCurPDFName
DoCmd.Close acReport, rptName, acSaveNo


End Sub

Probably include the URL's to both this thread as well as Welshgasman's right in the comment block of the sub.