Specific Printer not selecting correct Papersize when printing/vie

[Guest]

Application: Access 2003 adp running on Windows XP pro.
I have reports that print on a Japanese postcard, 8.5x11, and 11x17 paper.
The printer is a networked HP5100tn with 3 trays configured for the above
paper sizes.

I needed to modify the Japanese postcard and 11x17 reports, on my
development system, that does not have the correct printer driver. When I am
ready to distribute the adp, I copy it to a production machine, and change
the "Specific" printer settings for the reports. This has worked well, until
this past month.

Now, the reports RANDOMLY print on the printer's default paper size of
8.5x11.
I recreated the adp, compacted & repaired, redid the "Specific" printer
settings to no avail.

The printer driver has been rechecked, and so have the settings...everything
appears to be fine. There have been no changes to the network.

Older versions of the same adp print correctly every time.

Suggestions, hints, clues, insights??

 

[SA]

PAH:

1.) You might try installing the driver from the production system on your
machine for development purposes. There's no need to have the actual
printer connected to be able to use the driver and configure your reports
appropriately.

2.) Access has a way of operating with reports that has been around since
version 1, where if a report is previewed and the user selects a new
printer, then the report will ALWAYS revert to that printer's default paper
and layout settings. So, its important that when you set to use a specific
printer, that you have the proper printer driver installed, and secondly,
that your app manage printer settings rather than allowing the user to
select the printer from print preview. To limit the selection of a printer,
you can create custom tool bars and menus that you can link to a report
which eliminate the "Print..." option. Then add a button to your form or
menu to print the report.

 

[Guest]

1. I have the same printer driver installed, but the client has a different
printer name that I cannot emulate.

2. It is the system manager that reconfigures the reports. The rest of the
users have no access to the printer configurations (these have been locked
down).

3. Once the reports are properly configured to print to the correct printer
and paper size and saved, the adp is closed. Opening the adp again, the
first time the special sized reports are opened (11x17), they revert to
8.5x11 on the first print and then print properly after that.

Further ideas?

: . . .

 

[SA]

PAH:

The issues is, that when a report is configured to use a specific printer,
that printer is determined by not only the printer driver, but also the
printer name and output port. If the "configured printer" which you save
is "not available" when the ADP is installed at the client location, due to
the change in printer name or port (e.g. a network printer) then yes, the
first time a report is opened, or when the new specific printer is chosen,
the report would reset itself to using the new printer's "default" paper
size and layout.

So, when the system manager "reconfigures" the reports, he or she needs to
open them and reset not only to the "specific printer" selection, but also
click on the "properties" button and reset up the paper size and layout. If
he or she does that extra step, then when the user first runs the report it
should work fine.

 

[Guest]

Precisely, the system manager resets the specific printer selection and also
selects the proper paper size and layout, and saves the configuration prior
to distribution.

The report is not "remembering" these settings.