G
Gridrunner
I am using Access 2007 on WindowsXP. I have a form where the user inputs
certain data for a work order. It has a 'Print Worksheets' button that brings
up a dialog allowing the user to select which worksheets (set up as reports)
they need for a particular job, since they can vary from one order to the
next for the same job type. The dialog also gives them the option of
previewing the worksheets before printing. If the user opts to view the
sheets, then they have to print them manually, via the standard print dialog.
All is well and good up to this point.
If, however, the user decides they don't need to preview, they can select to
print immediately. This works fine most of the time; however once in a while
one of the worksheets (it is always the same one) will spit out five copies
instead of one. If you then go back through the "Preview before printing"
option, and go to the print dialog, the "Number of Copies" box has the number
5 in it, not 1. I can then set it back to 1, and it will work fine for a
while until it decides to hiccup again. No one is manually setting this
number.
Nowhere in my database do I ever tell it to print five copies of anything,
so I have no clue where this is coming from. Is there a way to
programmatically set the number of print copies in this dialog? If so, I
could force it to 1 every time before printing, but I cannot find where to do
it (if it is even possible).
Thanks!
- Jim
certain data for a work order. It has a 'Print Worksheets' button that brings
up a dialog allowing the user to select which worksheets (set up as reports)
they need for a particular job, since they can vary from one order to the
next for the same job type. The dialog also gives them the option of
previewing the worksheets before printing. If the user opts to view the
sheets, then they have to print them manually, via the standard print dialog.
All is well and good up to this point.
If, however, the user decides they don't need to preview, they can select to
print immediately. This works fine most of the time; however once in a while
one of the worksheets (it is always the same one) will spit out five copies
instead of one. If you then go back through the "Preview before printing"
option, and go to the print dialog, the "Number of Copies" box has the number
5 in it, not 1. I can then set it back to 1, and it will work fine for a
while until it decides to hiccup again. No one is manually setting this
number.
Nowhere in my database do I ever tell it to print five copies of anything,
so I have no clue where this is coming from. Is there a way to
programmatically set the number of print copies in this dialog? If so, I
could force it to 1 every time before printing, but I cannot find where to do
it (if it is even possible).
Thanks!
- Jim