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

Posted on 2011-05-12
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
    LVL 77

    Expert Comment

    Are the two pcs identical?

    Author Comment

    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
    Under what scenario does this function normally...?

    Accepted Solution

    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    We have adopted the strategy to use Computers in Student Labs as the bulletin boards. The same target can be achieved by using a Login Notice feature in Group policy but it’s not as attractive as graphical wallpapers with message which grabs the att…
    When I recently replaced my image transfer kit on my office HP color laserjet 5550dn printer, I had a slight problem.  The left bracket that holds the transfer kit got stuck in the upright locked position instead of being at a 45 degree angle facing…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now