Hpw can I use the same label format?

I created a label to print some selected records from Access with the Filter
option.
Next time, if I want to print different records from the same Access file.
How can I use the same label created, instead of recreating the same label
format everytime I want to print other records?

Instead of including the filter in the label report, leave the

Instead of including the filter in the label report, leave the report
unfiltered so that by default it would print all labels.  You can then
restrict which labels are printed at runtime in various of ways:

1.  Change the report's RecordSource to a query with one or more parameters
which prompt you to enter a value or values by which to determine which
labels are printed when the report is opened.  This is the simplest approach.

2.  Create a dialogue form to open the report and include controls on the
form in which you can enter or select values to determine which labels are
printed.  A button on the form to print the labels would then filter the
report to the relevant labels by building a string from the values entered in
the controls on the form.

3.  A combination of the above.  In this case the parameters in the report's
RecordSource query are references to the controls on the form, and the button
on the form simply opens the report without the need for any code to filter
it.  The parameters can be made optional by testing not only for a value in
each but for the parameter being Null, so you can enter values in as few or
as many of the controls on the form in combination as you wish.

If you can post back with more details of the ways in which you wish the
report to be filtered we can be more categorical.  It would help if you also
post the report's current RecordSource as the SQL of the query, or if the
RecordSource is a table, the names and data types of the fields in the table.

Ken Sheridan
Stafford, England


--
Message posted via http://www.accessmonster.com

Hi Doug,You can base your label report on a query that includes the

Hi Doug,

You can base your label report on a query that includes the criteria
appropriate for the labels you want to print. Open your label report in
design view. Access the properties for this report, and follow the record
source. Is the record source a table? If so, convert it to a query.

You can even have a query that gets the appropriate criteria from an open
form. So, for example, you could select all people who live in a given city,
or you could enter a Zip Code (Postal Code) and print labels for all people
with a given postal code.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

Good morning Doug W.Thankyou for your help.

Good morning Doug W.
Thankyou for your help.  Now I am able to view the selected records that I
want to print from my Query.
But, how can print these selected records on differents labels. I created
the Label with the appropriate fields. It should print 10  labels on a
8.5"x11 sheet    I created my Query based on my label report. Thank you.

Good evening Tom,I found the answer to my question.

Good evening Tom,

I found the answer to my question.  All what I did was  from the Table I
filtered (selected) the Records I wanted it.  Then I created the Label and
from that report only the labels for those filtered records printed. Again
thankyou for your help.
Your previous reply really help me.

Good evening Tom,I just reviewed your reply one more time, and yes the light

Good evening Tom,
I just reviewed your reply one more time, and yes the light came on, your
solution works much better and I will use it in the future. Thankyou very
much.

You're welcome. Glad you got it working!

You're welcome. Glad you got it working!


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

Hi Doug,Glad to help.

Hi Doug,

Glad to help. Earlier, I mentioned how you can use a form to get the
criteria for a query. Here is a sample database, with Word document, that
explains the technique:

http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

Good evening Ken,Thankyou for your reply, it really helped in founding out the

Good evening Ken,

Thankyou for your reply, it really helped in founding out the solution to my
question.

Doug,