Hiding the print dialog after a print command

[ind]

Is there a way to hide/disable the printing prompt after click a button command for a print action????????


I want to create my own printing prompt screen, instead of the windows default one.

Thanks

 

[ind]

Still waying on a reply.
I appreciate the help!!!!!!!!!!!!!!!!!!!!!!

 

[tlbroadbent]

You can prevent the print dialog by using the OpenReport Method (for reports) or the PrintOut Method of DoCmd in you button click event. The syntax follows.


DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]

DoCmd.PrintOut [printrange][, pagefrom, pageto][, printquality][, copies][, collatecopies]

Read more about this method in VBA HELP.

Terry

X-) "I don't have a solution, but I admire your problem."