Set Warnings does not work

[LeonS]

Hello! Leon here! I have a button which, when pressed, prints out details of the person's record, identified by their ID code. It works perfectly, except it shows the printer dialogue box - which I do not want the user to see. The question is, how do I stop the dialogue box from appearing. I am using Warnings and Echo !!?? And I have made an adjustment in the Options facility. Thank you.

 Private Sub PrintContactDetails_Click()On Error GoTo PrintContactDetails_Click_Err


    DoCmd.Echo False, ""
    DoCmd.SetWarnings False
    DoCmd.RunMacro "PrintReportNew", , ""
    DoCmd.SetWarnings True
    DoCmd.Echo True, ""


PrintContactDetails_Click_Exit:
    Exit Sub


PrintContactDetails_Click_Err:
    MsgBox Error$
    Resume PrintContactDetails_Click_Exit


End Sub.....

[Minty]

I think you need to set the option to print the report directly.

Because you are using a macro I can't tell what command you are using to print the report.
And why use a macro for that bit when you are using code for the rest of it?

[mike60smart]

Best to just use a DoCmd RunMacro and set the warnings on / off in the Macro

[moke123]

use acviewnormal in your docmd.openreport arguments.

[Minty]

Warnings on/off won't stop the print dialogue showing up. It's not a warning.

You need to use a method that simply prints directly to the printer.
In VBA

DoCmd.OpenReport "rptYourReport", acViewNormal

Would normally simply print the report directly to the default printer for that report

[LeonS]

Thanks for that - Mike60Smart - but it does not work!! It works elsewhere but not in that macro. But i will try again, by re-writing the macro! Thanks.

[LeonS]

Moke123 - thanks for that. An interesting option - I will try. Thanks!

[moke123]

Moke123 - thanks for that. An interesting option - I will try. Thanks!

It's not an option Leon, it's how you send a report direct to printer.
See Mintys post #5.

[LeonS]

My apologies for the wrong use of a word!! Please remember that I am but a small bush in a forest of tall trees!

[LeonS]

Moke123 - I have changed the code as follows:

DoCmd.Echo False, ""    DoCmd.SetWarnings False
    'DoCmd.RunMacro "PrintReportNew", , ""
    DoCmd.OpenReport "ContactR", acViewNormal
    DoCmd.SetWarnings True
    DoCmd.Echo True, ""

And this is what happens on screen

[Minty]

That isn't a print dialog - it's asking you for a parameter, presumably for the underlying query that the report is based on.
You probably need to supply that or make sure the form it is referenced on is open.

Remove all that set warnings and echo stuff, it's not achieving anything, other than possibly hiding some genuine error codes.

[LeonS]

Minty - I have removed all the Warnings and Echo stuff, as you suggested. There is still a message/ dialogue box opening and going away. This is apart from the message box that asks for the ID number.
My methodology is that there is a Report. Which of the contacts details are printed on that report depends on their ID number. The query has an [Enter....] criteria in the ID field. Thus when you open the query, the message box asks for the ID number. So far so good. The code behind the "Print" button is below.
But behind the Criteria request message box there is a "dialogue" box that appears. I cannot see the content but I believe it is just saying "The report is being printed". I would like for that other message/ dialogue box, not to appear. If you have another look at the screen print I sent you, you will see 2 boxes. The ID Request box (meant to be there) and, behind it, the other dialogue/ message. I hope this helps. It is the only print request button in the db, so I have nothing with which to compare.
Could it be a print setting within the db or in the printer setup? The printer is the default printer connected to the PC. Leon

Private Sub PrintContactDetails_Click()On Error GoTo PrintContactDetails_Click_Err


    DoCmd.OpenReport "ContactR", acViewNormal


PrintContactDetails_Click_Exit:
    Exit Sub


PrintContactDetails_Click_Err:
    MsgBox Error$
    Resume PrintContactDetails_Click_Exit


End Sub

[moke123]

Thats the "Printing" dialog, not the "Print" dialog.

see this article which states it cannot be hidden but can be minimized. I've never used it but give it a shot.

http://access.mvps.org/access/api/api0037.htm

[LeonS]

Thanks for that. Amazing! First because you found it - deep research! and because of the knowledge Dev must have of Access. To be honest, there seems (to me!) to be too much that could go wrong. The next time I am in Lockdown, I may give it a try!!! I truly Thank You for your efforts. Leon