Print a report from within a VBA procedure in Print Preview mode

[Phil H]

I'm trying to print a report from within a VBA program. I can't seem to get the syntax right, it always goes directly to the printer. Help says that you can somehow specify Print Preview via the "acView" parameter, but gives no example to follow and I haven't found the secret. I've tried various versions of code:

 DoCmd.OpenReport "Rankings"

w/o the acView at all, this goes directly to printer

 DoCmd.OpenReport "Rankings", acViewNormal

This one sends report directly to printer

 DoCmd.OpenReport "Rankings", acView = PrintPreview

Type mismatch error

 DoCmd.OpenReport "Rankings", acViewPrintPreview

No error, report still goes to the printer.
I've tried other variations as well, but to no avail.
I'm running Access 2007, 2016 File Format. Thanks in advance,


Phil Howard (phil.c.howard@centurylink.net)

[June7]

Intellisense popup should give you list of options.

DoCmd.OpenReport "Rankings", acViewPreview

[Welshgasman]

[QUOTE=Phil H;519852
Phil Howard (phil.c.howard@xxxxxxxxxxxxx.net)[/QUOTE]

I would not put your email address on any posts. That can get harvested and then you will get spam galore.

[Welshgasman]

Here is what I used to use

Private Sub cmdShip_Click()
On Error GoTo Err_cmdShip_Click


    Dim stRptName As String, stParam As String, stLinkCriteria As String, stDBpath As String, stFTPpath As String
    Dim iPreview As Integer, iDialog As Integer, blnPrintIt As Boolean
    
    stDBpath = CurrentProject.Path & "\"
    stFTPpath = stDBpath & "Gazette\"
    iPreview = acViewPreview
    If Me.ChkPreview Then
       ' iPreview = 2
        iDialog = acWindowNormal
    Else
        iDialog = acHidden
    End If
    
    stRptName = "Main_by_Ship"
    
    stParam = Replace(LCase(Me.cboShip.Value), " ", "_")
    stLinkCriteria = "[Ship] = '" & Me.cboShip.Value & "'"
    
    'DoCmd.CopyObject , stParam, acReport, stRptName
        
    If Me.ChkPreview Then
        DoCmd.OpenReport stRptName, iPreview, , stLinkCriteria, iDialog
    Else
        DoCmd.OpenReport stRptName, iPreview, , stLinkCriteria, iDialog
        DoCmd.OutputTo acOutputReport, stRptName, acFormatPDF, stFTPpath & stParam & ".pdf", False
        DoCmd.Close acReport, stRptName
    End If
    'DoCmd.DeleteObject acReport, stParam


Exit_cmdShip_Click:
    Exit Sub


Err_cmdShip_Click:
    MsgBox Err.Description
    Resume Exit_cmdShip_Click
    
End Sub

chkPreview is a checkbox that I used to see report in Print Preview

[Phil H]

I'm trying to print a report from within a VBA program. I can't seem to get the syntax right, it always goes directly to the printer. Help says that you can somehow specify Print Preview via the "acView" parameter, but gives no example to follow and I haven't found the secret. I've tried various versions of code:

 DoCmd.OpenReport "Rankings"

w/o the acView at all, this goes directly to printer

 DoCmd.OpenReport "Rankings", acViewNormal

This one sends report directly to printer

 DoCmd.OpenReport "Rankings", acView = PrintPreview

Type mismatch error

 DoCmd.OpenReport "Rankings", acViewPrintPreview

No error, report still goes to the printer.
I've tried other variations as well, but to no avail.
I'm running Access 2007, 2016 File Format. Thanks in advance,
Phil Howard (phil.c.howard@centurylink.net)

Response from June7 solved my problem. I want to mark as solved, but can't find the "mark as solved" dropdown. Also, not sure this is the right place to put reply, and I don't understand "use # icon on toolbar when posting code snippets."

[Welshgasman]

Also, not sure this is the right place to put reply, and I don't understand "use # icon on toolbar when posting code snippets."

So how did you pust your code within code tags?
Solved is top right of thread in Thread Tools.

[Phil H]

I used

....my code...

which I picked up somewhere in Forum instructions, I think.
Phil H

[June7]

Interesting, new to me.

Can just click # icon on edit toolbar and paste code between tags.

[Welshgasman]

No, you would have used
[ c o d e ] and [/ c o d e] without the spaces.

That is how I normally enter code myself, but for newbies who just pasted a whole block of code into the post and lose all the indentation, the # icon/button is the easier way?