printing a report from a access.mde

[kingz2000]

Hi,

short question: I've compiled an mde file which produces a report. Unfortunately, the 'printing' option is not visible in the menu bar. How do I make the report printable?

Thanks in advance.

Kingsley

 

[Remou]

You could add a custom button with a function:

Function PrintButton()
'This is for the menu, to allow the user to choose
'print options.

On Error GoTo HandleErr
    
    DoCmd.RunCommand acCmdPrint
    
Exit_Sub:
    Exit Function
    
HandleErr:
    Select Case Err.Number
        Case 2501 'User cancelled
            Err.Clear
            Resume Exit_Sub
        Case Else
            MsgBox Err.Description
    End Select
End Function

 

[kingz2000]

yeah, I just used the report assistant to create a print button in the end...thanx..