none
Print Dialog Box

    Question

  • Hi,

    I havde created a print button on a form using the following procedure:

    Private Sub cmdPrint_Click()
    On Error GoTo Err_cmdPrint_Click


        DoCmd.PrintOut

    Exit_cmdPrint_Click:
        Exit Sub

    Err_cmdPrint_Click:
        MsgBox Err.Description
        Resume Exit_cmdPrint_Click
       
    End Sub

    However, I would like it to call the Print Dialog Box from where users can select a printer.

    Could someone help me on this. I am using MS Access 2007.

    Thank you.

     

    Sunday, June 27, 2010 4:38 PM

Answers

  • Hi,

     

    you may try: DoCmd.RunCommand acCmdPrint


    Hope to Help - Jörn
    • Marked as answer by KKbondo Monday, June 28, 2010 11:42 AM
    Sunday, June 27, 2010 5:59 PM