Turn Off Print Dialog Box

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

How do you turn off the box that comes up when you prin that says...
Printing Page 1 etc.....
Thanks
DS
 
This will depend in part on whether this is the Windows dialog or one
generated by your printer driver. If it is the Windows dialog, see this
article:

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

If it's generated by your printer driver, you'll need to see if there is a
setting in the driver to suppress it.
 
Wayne said:
This will depend in part on whether this is the Windows dialog or one
generated by your printer driver. If it is the Windows dialog, see this
article:

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

If it's generated by your printer driver, you'll need to see if there is a
setting in the driver to suppress it.
Click to expand...
Thanks, I tried that and it didn't work....perhaps the reason it didn't
work is that I didn't know what to name the code I pasted into the
module? Sorry (Still a Newbie!).
DS
 
Wayne said:
Ok, the code in the first blue box goes where it is mentioned it goes. The
On Timer line on the Events tab of the form's Properties sheet should read
[Event Procedure].

The code in the second blue box goes in the click event of the button you
click to open the report. Adjust the report and form names to match the ones
in your database.

The code in the third blue box goes in a standard module that you would
create in the Modules window of the main database window. Give the module a
unique name, not something that will appear in any procedure (i.e.
basHidePrintDialog). Just copy and paste all of the code in the third blue
box into this module right after the lines "Option Compare Database" and
"Option Explicit". It will automatically break down into the separate
procedures.

If you don't see "Option Explicit", add it right below the line "Option
Compare Database". Also, in the code editor, go to Tools|Options and check
the box "Require Variable Declaration". This will automatically add the line
"Option Explicit" to any new module (standard, form, or report). I would
recommend going back and adding the line to any modules you already have.
This will force you to declare your variables (Dim statements), but will cut
down on typos because the compiler will flag anything you've misspelled
instead of just assuming it to be a new variable.
Click to expand...

OK Wayne, it works. But is there any way of speeding it up. I see it
open then I see it reduce. I want to either block it, get rid of it,
replace it with my own form saying "Sending Items", or make it move quicker.
Thanks
DS
 
Back
Top