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

Posted on 2011-05-12
Medium Priority
Last Modified: 2012-05-11
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.
Question by:rutlandict
  • 3
LVL 77

Expert Comment

ID: 35745913
Are the two pcs identical?

Author Comment

ID: 35746208
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.

LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35747024
Under what scenario does this function normally...?

Accepted Solution

rutlandict earned 0 total points
ID: 35832144
I'm afraid our client has now purchased a new smart label printer for the second PC. Sorry for waisting your time.

Author Closing Comment

ID: 35872671
I'm afraid our client has now purchased a new smart label printer for the second PC. Sorry for waisting your time.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question