Error "The run command action was cancelled" while making labels

Question

Dear Sirs:

I want to make labels for selected records in a datasheet.  I get the following messages:

"The run command action was cancelled"

and

"The expression you entered refers to an object that is closed or doesn't exist"

Please help.

Vty,

Shel

Answer 1

Hi Karl,

I made a datasheet composed of 20 records with various fields.  I go to "labels" in the "reports" section in the "create" tab. I then get the "label wizard" and follow through the various windows.  After I hit "finish," I get some type of composition pane with these two error messages.  I want to be able to print simple labels with various standard fields.  I also want to be able to select records and print, e.g., ten of those records as labels.

Please help.

Very truly yours,

Sheldon

Answer 2

I think you might be misunderstanding the purpose of the Labels option on the Create ribbon.  What this does is create a labels report by taking you through a series of design options in a wizard.  At what stage in this process is the error occurring?

If you want to create labels based on a subset of rows in the relevant table or query, having created the report, you will then need some means of filtering it.  The simplest way of selecting an arbitrary set of rows for which the labels are to be printed is by means of multi-select list box in a dialogue form.  You'll find examples of this, amongst other things, in MultiSelect.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to amend the form design accordingly.  

If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.

In this little demo file the first two buttons on the opening form allow you to restrict a report on the basis of selections in a multi-select list box.  One illustrates how to filter the report, the other how to restrict its recordset.  The end result is the same in both cases, only the methodology differs.

In my demo the report is not a labels report, but that's not relevant.  The same methodologies can be applied to any kind of report.

Answer 3

 I'm merely using the filter to choose my records a using the labels button in the "create" tab.  

You say "create tab" as if you are in some form.   Did you create the form?  If not then who did?

Answer 4

Hi There,

I a not using any code.  I'm merely using the filter to choose my records a using the labels button in the "create" tab.  I figure it should be pretty straight forward.

Thanks,

Sheldon

Answer 5

How are you making the selection?

Post the code you are running to perform the action.