Code errors on 1 machine but not another??

[Nelmo]

I have a client/server application running on two pc's on a network. It is a simple order system.
On the order form there is a print button to print preview the order.
The front end is exactly the same on both pc's. However, on one when the print button is clicked the order is print previewed, while on the other the following message is displayed:

"The OpenReport action was cancelled
You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box"

There is no difference in the code behind the print button in these applications.

The only difference between the machines is that one runs Windows 98 and the other Millenium, both use Office 97.

completely at a loss, any thoughts please.

 

[D B Lawson]

On the machine that is giving you the problem, remark out the error handling code on the print button, click the button and see what piece of code is giving you the problem. The error handling message could be masking the real problem. It might be something as simple as a missing reference library on that machine.

 

[Nelmo]

Thanks for the reply and suggestion DB.

I have found the cause of the problem.

The user's PC shares two printers through a switch. An A0 Plotter and an A3/A4 inkjet. He had it defaulted to the plotter, default to the A3 and everything works fine.

Is there any way to check in code if a suitable (A3 or A4) printer is the default? Or to designate an avialable network printer as the default from a print button.