Strange printer behavior

T

TomT

I have recently converted an Access 97 application to Access 2003

I've installed this as a runtime on several users' systems for testing purposes. These are Windows 2000 machines

On two of these systems, there is a problem with reports formatted to print in landscape. The reports do one of two things, either they display on screen as landscape, but print portrait, or, they display as portrait and print portrait

In each case, in page set up the orientation is set to landscape. Changing the orientation to portrait, and then back to landscape seems to temporarily solve the problem, however not permanently

In each case, the systems are connected to a network printer

Are there any known issues with this problem? The Access 97 version has had no such problem, with the exact same report and printers

Some other users testing this 2003 runtime do not have the problem, so it's a bit of a mystery

Thanks for any assistance....
 
Y

Yuan Shao

Hello,

Thanks for your post. If I understand correctly that Microsoft Access
report suddenly is not printed as expected. Based on my experience,
sometimes the problem can be caused if the printer drivers are not
compatible with each other and some of the settings are not transferable
between printer drivers. Please make sure the orientation property setting
of the in "printer¡­" and "page setup" is consistent. In the meantime,
please perform the following steps to disable Name AutoCorrect by following
these steps:

a. On the Tools menu, click Options.
b. In the Options dialog box, click the General tab.
c. Click to clear the Perform name AutoCorrect check box.
d. Click OK.
e. Quit and then restart Access.

Does it fix your problem? If not, please provide the detailed reproduce
steps on the sample database Northwind.mdb so that I can perform further
research on my side.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
S

SA

Mike:

Unfortunately based on the user's post, this won't work, because they are
using the run time version of Access and as you know there are no "Options"
menu items in the run time version.

Tom:

The problem you may be seeing is that if the user is previewing the report
prior to selecting a printer, and then changes printers, what Access has
always done, A97 or A2003, is to "adopt" the default paper and layout
settings for the selected printer when the printer is changed via the print
dialog. So if your network printer's default layout is portrait then when
the user selects that printer from a preview, it will always hose your
report.

The only work around to this is to remove the "Print" option from the
preview toolbars and menus that you may have created, and to set your report
to use the default printer. Then put a print button on your form and a
preview button on your form. Use a combo box to present the user's with
the various printers available (using the Application.Printers collection)
and when they change printers in the combo box, set the Application.printer
to that printer as the default. Then since there's no preview, the report
settings will not "adopt" the default layout of the printer selected, but
rather, the report's internal settings (i.e. landscape) will be retained
when the report is sent to that printer.

If you want another method to change the default printer and to present your
user with a printers combo, then take a look at our "On the Fly Printing
classes on our web.
 
T

TomT

Thanks for your reply. I did not completely understand some of your comments, e.g. "sometimes the problem can be caused if the printer drivers are not compatible with each other and some of the settings are not transferable
between printer drivers

This is a runtime installation of 2003, and the database it was created from did not have the Autocorrect options turned on. The settings for the page (landscape) match the settings for the printer. However, I was able (at least so far) to get the reports to print correctly by going into the properties for the printer, and changing the default page layout to landscape

I don't like this as a solution, since having to do this indicates there is something wrong somewhere. I will add that on the same machine, a runtime installation of Access 97 does not exhibit the printing problem. That is, using the same printer, the A97 app prints landscape properly, when it should, without having to force it to

The printer is an HP LJ4000, on a network print server, and we've tried PCL 5 and PCL 6 drivers, with no luck

Thanks for your assistance
 
Y

Yuan Shao

Hi Tom,

Thanks for your feedback. I apologize for my confusion setting the
autocorrect option in the Access runtime version. Based on my test, when
trying to configure the print setting with report object in Access 2003,
the print setting called form "page setup¡­" command and "print¡­" command
is specific to the report objects, which is different from the print driver
setting of the printer in the "Printers and Faxes" folder

The behavior you described is strange. Can you please collect the following
information for me so that I can narrow down this issue?

1. "The settings for the page (landscape) match the settings for the
printer."
Can you please tell me how you check the orientation property of the page
or the printer under the Access runtime version?

2. "On two of these systems, there is a problem with reports formatted to
print in landscape. The reports do one of two things, either they display
on screen as landscape, but print portrait, or, they display as portrait
and print portrait.
"
When the problems mentioned above occurred, what is the print setting of
the printer driver? I mean you go to the "Printers and Faxes" folder and
then choose the property of the destination printer.

3. "Changing the orientation to portrait and then back to landscape seems
to temporarily solve the problem, however not permanently."
What do you mean by "not permanently"? Do you mean the same problem occur
again when you print the same report again?

4. "I was able (at least so far) to get the reports to print correctly by
going into the properties for the printer, and changing the default page
layout to landscape."
Do you mean that you go into "Printers and Faxes" and set the property of
the print but not clicking the "printer¡­" command?

Also, such weird issues tend to be complex and take up extensive research
time. I'd like to set your expectations that it may take a while for us to
help you narrow down the problem and we may eventually redirect you to PSS
to continue working with a dedicated Support Professional. If this is
critical, I'd recommend contacting PSS and opening a Support incident
troubleshoot this further. If you need any help in this regard, please let
me know. Thanks for your understanding.


Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
T

TomT

1. "Can you please tell me how you check the orientation property of the page
or the printer under the Access runtime version?
The orientation is checked (and also can be set) via a menu I created which includes Page Setup commands

2. "When the problems mentioned above occurred, what is the print setting of
the printer driver? I mean you go to the "Printers and Faxes" folder and
then choose the property of the destination printer.
The printer driver is set to portrait in this case, which is the default I believe, for most printers

3. "What do you mean by "not permanently"? Do you mean the same problem occur
again when you print the same report again?
By not permanently I mean eventually the report reverts to displaying and/or printing incorrectly. It may not be right away, but within a relatively short period of time

4. "Do you mean that you go into "Printers and Faxes" and set the property of
the print but not clicking the "printer¡­" command?
Yes, by going into the printer properties via "Printers and Faxes". However by setting this to be landscape instead of portrait, other reports that should be portrait print landscape

"Also, such weird issues tend to be complex and take up extensive research
time. I'd like to set your expectations that it may take a while for us to
help you narrow down the problem and we may eventually redirect you to PSS
to continue working with a dedicated Support Professional. If this is
critical, I'd recommend contacting PSS and opening a Support incident
troubleshoot this further.

I am reluctant to contact PSS, as I've already used up a support incident on another bug in Access 2003, without satisfactory resolution. I was hoping to migrate our office to Office 2003 soon, but with this kind of problem I'm beginning to wonder if I shouldn't just stick with Access 97...

Thanks for your help

Tom
 
U

Ulrich Jenzer

Hallo NewsGroup

I have near same Problems postet in
microsoft.public.de.access (Sorry it is German)
Sbject: ACC02 Bericht Überraschung
and
Subject: AXP: Probleme mit Laserdrucker
but not found any solution.

Ulrich Jenzer
 
Y

Yuan Shao

Hi Tom,

Thanks for your feedback. This weird problem tends to be complex and hard
to find the root cause.Currently, I am performing some further research. We
will update you as soon as possible. In the mean time, if you have any
other useful information, please feel free to let me know.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
T

TomT

Michael

Thanks for your efforts on this, I will continue our testing of the 2003 runtime, but will hold off on actually deploying until we get a resolution to this problem

I'll look forward to hearing from you

Tom
 
O

Orlanzo Ross

Hello Tom,

My name is Orlanzo Ross and I work with the Microsoft Access support group
in Charlotte, NC.

As I understand, report printer settings are not being retained when the
database is moved to another machine. The peculiarities of the behavior
you describe are very unusual.

Some printer information is stored with the report. Their are occasions
when that information will be reset. Using a network printer has been
shown to be a primary cause. But, their are other factors to consider.

See the following articles for more information. Please note some of the
material is titled for Access 2000. The information will also apply to
Access 2003.

208912 ACC2000: Changing Printer Port Resets Printer Setup Information
http://support.microsoft.com/?id=208912

290293 Printer Properties Not Inherited by Objects That Use the Default
Printer
http://support.microsoft.com/?id=290293


I would also suspect the issue is not limited to an Access Runtime. Can
you temporarily install the full version of Microsoft Access 2003 on a
client machine? Are you able to observe the identical behavior as
experienced by the runtime? That would be a valid test for us to determine
whether the issue is runtime specific.

Beginning with Access 2002, the Printer Object Model was introduced. This
allows considerable flexibility when working with installed printers. You
may be able to define the appropriate configuration prior to opening the
report for presentation.

319317 How to Automate the Process of Selecting the Printer for a Report
http://support.microsoft.com/?id=319317

Their was a much more exhaustive example available at
http://www.microsoft.com/access. I will see if I can locate the actual
link and forward it to you.

Please feel free to post any questions or concerns!

Best regards,
Orlanzo Ross
Microsoft Online Product Support
 
O

Orlanzo Ross

Hello Tom,

Thank you for the clarification!!

Well, that is a very - very peculiar issue. This could be a predicament
with the print driver. But, I am not certain at present.

Can you provide me with additional information:

1. What is the make/model of the printer attached to the affected systems?
2. Is the same printer used on the systems unaffected by this issue?
3. Are clients connecting via a shared printer or are they printing
directly to a TCP/IP printer port?
4. Do all clients have the same version of the printer driver? Is it the
latest driver available from the manufacturer?
5. Some printer models are capable of using a PostScript or PCL driver. If
a machine is using the PCL version, try changing to the PostScript driver
or vice versa.


I would be interested in knowing if the issue has a direct relationship to
the Access Runtime. However, try to address my questions above before
installing the retail version of Microsoft Access on a client machine.


Kind regards,
Orlanzo Ross
Microsoft Online Support Services.
 
Top