Contextual Print Preview Button for Report.

[Mrkeith]

Can anyone help me create a Print and Print Preview button or tab for my report. I've lock down the database so the ribbon doesn't show on but I need a print tab or button to print out the report.

Thanks in advance.

 

[Steve R.]

You need to create a command button on your form. Adapt the code below.

Private Sub Command29_Click()
    Rem Print Preview
    Dim strDocName As String
    strDocName = "FilteredPrintRPT"
    DoCmd.OpenReport strDocName, acViewPreview, , strFilterCriteria, , Me.Name
End Sub

 

[Mrkeith]

Steve, I don't believe this is what i'm looking for. I don't wish to create a button on the report. I need to be able to click the print button from the ribbon that only has a button to print and print preview.

 

[Steve R.]

I have not used that approach. Try this, on the upper left there is a globe with the MS logo. Click on it and choose "Access Options". The select "Customize". Under "Popular Commands" you should be able to see "quick print" and "print preview". After adding them to the column the right they appear at the very top, above "Home". Is that what you were after?