By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,122 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.