Using Access 2010 Problem with printing labels correctly

Question

I'm using Access 2010. i have a database. I'm only trying to print a selection from this database. The ones I have selected show up on the screen. When I generate the label and do a print preview all the labels in the database are in the file to be printed. How do I just print the selection.

Prior to me updating my computer it used to work and now its now. Any help is greatly appreciated.

Answer 1

From your description I take it that you have a Boolean (Yes/No) column in the table which you are using to select specific rows.  You are then filtering the table's datasheet to those rows via the Selection icon in the Sort & Filter area of the Home ribbon.  Right?

Filtering the table's datasheet in this way will not filter the label report's RecordSource, however.  To do that the RecordSource should be a query which includes the following WHERE clause:

    WHERE [NameOfBooleanColumnGoesHere] = TRUE

Note that, with this addition to the report's RecordSource, there is no need to filter the table's datasheet.  You merely need to update the values in the Boolean column by selecting the check box in each of the rows you wish to be returned by the label report.  You can then open the report, which will be restricted to the selected rows.

Answer 2

It sounds like you have a checkbox field for Selected, but you don't say whether you are filtering the labels for that. You are filtering your form, but not necessarily the labels. What is the Recordsource for the labels?

Answer 3

I’ve never experienced your method of applying the table’s filter to a report. What happens if you skip the print preview?

I would use a form so you can use it’s filter property in the Where clause of DoCmd.OpenReport.

Answer 4

Yes "on the screen" is print preview mode

I'm selecting within the table. I"m then Clicking the check box on the side and then on the top selecting the icon that has the funnel, with the lighting bolt. From there I'm clicking on "Is Selected"

So at this point these names are the only ones showing up on my table.

Answer 5

How are you making a “selection”? When you state “show up on the screen” is this Print Preview mode?

There are many methods for filtering a report. I prefer using a where condition in VBA.