Default printer issues

[Guest]

I have an application that is being used by 50+ people in two locations all
sharing a single SQL db.

For some users one report prints at the printer the developers used. A
different person can sign on at the same machine and the report will go to
the desired (default) printer.

Also if the user that is having the printing problem selects a different
network printer as the default the report goes to the 'new' default printer.
The original default printer is an HP4050. Setting it back to the HP4050
causes the problem to start again.

The report prints as a single report but contains 20+ subreports. I have
gone to each of these reports in design mode and checked to see that the
report is set to use the default printer. All, the main and all sub reports
are set to use the default printer.

Any ideas as to what could be causing this.

 

[Guest]

Is the default printer being changed by code somewhere and not being reset?

JFercan

 

[Guest]

No there is no change to the default printer in the application.

 

[SA]

Cliff:

I don't know what version of Access you are using but it sounds like Access
2002 or later. The way that application works, is that the first printer
chosen by a report or a user, is then set as the application's overall
default printer for all subsequent reports UNLESS, you change it to a
different default via code. So, what I suspect is happening is that either
with a report set to a target printer is printed first or the user is
selecting a different printer (for a different report,) or via code, the app
sets the default to a different printer before your specific target printer
is set. So to make the app work properly, have your code choose the windows
system default as the application's default printer prior to sending your
report to print.