Printing reports from different trays without locking the db in design mode

[eskil]

Hi,
I have an invoice which is being printed on two different trays. This
is being done by some simple code in VB, and it works.

However, my report goes into design mode in order to change the
settings for the printer, and this locks the system for new users to
enter and a restart of the database is the only solution.

Is there a way to avoid putting the report into a design mode when
printing from 2 different trays, or is there another way of solving
this issue.

I use Access 2003.

THank you for your help

Eskil

[corey lawson]

eskil wrote:

Hi,
I have an invoice which is being printed on two different trays. This
is being done by some simple code in VB, and it works.

However, my report goes into design mode in order to change the
settings for the printer, and this locks the system for new users to
enter and a restart of the database is the only solution.

Is there a way to avoid putting the report into a design mode when
printing from 2 different trays, or is there another way of solving
this issue.

I use Access 2003.

THank you for your help

Eskil

Make a copy of the report, and setup the copy to print to the second
tray. Then you should be able to programatically control when each
report gets printed.