Report Printing Duplex Need Simplex

[Guest]

I converted an Access2K application to Access2003. One of the reports in
this application prints on a legal-size preprinted form and is to print
single-sided. It worked fine when the application was in Access2K but now
something has changed and the report prints duplex. The application is using
an executable. The report when looked at in design mode, is defined and
saved correctly. Because the application uses an MDE, I can't change the
settings via VBA code - the MDE won't allow it.

When I tested the application at the customer's site, it printed the reports
correctly on the preprinted form - single sided. I don't know what has
changed at the customer site, but now the reports print duplex regardless of
whether or not the default printer is set to single sided in the Windows
Printer settings. The PC is running WinXP Pro with Office 2003.

I have tried changing the printer default on the report but Windows or
something keeps overriding it. Now this report prints correctly on my PC
[running Win2K, Office XP, Access 2003]. I use a different server and
printer than does my customer running this application - we are in different
locations.

Any help would be greatly appreciated.

Thanks

 

[SA]

Nancy:

A few basics about Access reports and printer set up. Access reports have
a property, called the prtDevMode, which specifies a lot of detail about how
a report should print. It includes items like duplex printing, paper
orientation, size etc. When a report is designed, if the printer (File ->
Page Set up) is set to the default printer or to a specific, the report
"assumes" and incorporates that printer's DevMode settings into its
prtDevMode property.

When a report is subsequently printed from a non-preview mode, it will apply
these saved settings to the output, that way your report retains settings
like landscape orientation, paper size and yes, duplex or simplex printing,
so that it overrides the default settings for the printer as set up in
Windows.

So, what has likely occurred is that at some point, your report when it was
designed was pointing to a printer that had its duplex settings set to True,
and that was saved internally in the report. To fix this, in your mdb copy
of the app, open your report in design mode, set it to use a specific
printer (some generic printer) click the printers properties and make sure
that it is not set to duplex printing. Save the report. Then set the
report to print to the default printer (or target printer if it has to go to
a specific printer at the client site) and save the report again. This will
wipe out the duplex setting, then convert it to an mde.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

I converted an Access2K application to Access2003. One of the reports in
this application prints on a legal-size preprinted form and is to print
single-sided. It worked fine when the application was in Access2K but now
something has changed and the report prints duplex. The application is
using
an executable. The report when looked at in design mode, is defined and
saved correctly. Because the application uses an MDE, I can't change the
settings via VBA code - the MDE won't allow it.

When I tested the application at the customer's site, it printed the
reports
correctly on the preprinted form - single sided. I don't know what has
changed at the customer site, but now the reports print duplex regardless
of
whether or not the default printer is set to single sided in the Windows
Printer settings. The PC is running WinXP Pro with Office 2003.

I have tried changing the printer default on the report but Windows or
something keeps overriding it. Now this report prints correctly on my PC
[running Win2K, Office XP, Access 2003]. I use a different server and
printer than does my customer running this application - we are in
different
locations.

Any help would be greatly appreciated.

Thanks