PrintOut and Dialog Box

[mmatsumura]

Hi all,

Posting this to ask if anyone knows a way to perform the PrintOut action without having the Print dialog box appear. I've looked through Access Help Topics and one book, but cannot seem to get that darn thing to quit showing up.

The DoCmd.PrintOut ,,,,, works great except that it prints exactly what I have on the screen at that time rather than what is created by launching the report.

Any assistance would be greatly appreciated!


MMM

Ps If this all sound foolish it's due to my just learning - really!

 

[james33]

Dear mmatsumura,

This is the code I use for printing out an invoice where the HireJobID (the primary key) is the same as that on the form I am printing from.

Private Sub cmdPrintHireInvoice_Click()
Me.Refresh
Dim strRptName As String
Dim strWhere As String
    strRptName = "HireInvoice"
    strWhere = "[HireJobID]=" & Me!HireJobID
    DoCmd.OpenReport strRptName, acPrintAll, , strWhere

End Sub

Obviously you will have to replace my report and field names with your own.
Good luck and I have to admit I got this code from someone here so, thank you whoever it was.
Regards Jim
;-)