Link to home
Start Free TrialLog in
Avatar of rutlandict
rutlandictFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Getting Microsoft Access error "The open report action was cancelled".

I am using a standard Microsoft Access database. I have 2 machines one with the smart label printer connected via USB. This printer is shared (i.e \\user\printer) to the second PC.
My problem is i can't print a label address from the database onto the smart label printer using the second PC. when i attempt to preview the label i get the following error "This document was previously formatted for the printer smart label printer 450 on USB002, but the printer isn't available.
It gives me 2 options first is to "preview" and second to select "setup"
If i select preview i get the following error; "The OpenReport action was canceled".
If i select "setup" i have the options for margins, page columns and the option to chosse either the default printer or select one from the list. My smart label printer isn't the default so i choose it from the drop down.
I have set the margins to the correct size and all other settings. There is only one option that is grayed out. This is for the paper size. The other machine has this set to 54mm x 101mm. For some reason i can't choose this option. The drop down just shows a blank list.
I have installed the smart label printer from the CD and drivers from the website. I though this may provide me with the settings for that drop down box. Unfortunately the list remains empty.

Any ideas?

Thanks in advance.
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Are the two pcs identical?
Avatar of rutlandict

ASKER

To peter57r:

They are identical. The only difference is the first PC has Access 2003 rather than 2002. But apart from this they are the same OS, files etc.

Thanks.  
Under what scenario does this function normally...?
ASKER CERTIFIED SOLUTION
Avatar of rutlandict
rutlandict
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'm afraid our client has now purchased a new smart label printer for the second PC. Sorry for waisting your time.