Hpw can I use the same label format?

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

Doug wrote:
>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?
 >> Stay informed about: Hpw can I use the same label format? 

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.


"Tom Wickerath" wrote:

> 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
> [URL="http://www.accessmvp.com/TWickerath/"]http://www.accessmvp.com/TWickerath/[/URL]
> __________________________________________
>
> "Doug" wrote:
>
> > 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?
 >> Stay informed about: Hpw can I use the same label format? 

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.

"Doug" wrote:

> 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.
>
>
> "Tom Wickerath" wrote:
>
> > 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
> > [URL="http://www.accessmvp.com/TWickerath/"]http://www.accessmvp.com/TWickerath/[/URL]
> > __________________________________________
> >
> > "Doug" wrote:
> >
> > > 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?
 >> Stay informed about: Hpw can I use the same label format? 

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.

"Tom Wickerath" wrote:

> 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
> [URL="http://www.accessmvp.com/TWickerath/"]http://www.accessmvp.com/TWickerath/[/URL]
> __________________________________________
>
> "Doug" wrote:
>
> > 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?
 >> Stay informed about: Hpw can I use the same label format? 

You're welcome. Glad you got it working!


Tom Wickerath
Microsoft Access MVP
[URL="http://www.accessmvp.com/TWickerath/"]http://www.accessmvp.com/TWickerath/[/URL]
__________________________________________

"Doug" wrote:

> 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.
 >> Stay informed about: Hpw can I use the same label format? 

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:

[URL="http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip"]http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip[/URL]


Tom Wickerath
Microsoft Access MVP
[URL="http://www.accessmvp.com/TWickerath/"]http://www.accessmvp.com/TWickerath/[/URL]
__________________________________________

"Doug" wrote:

> 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.
 >> Stay informed about: Hpw can I use the same label format? 

Good evening Ken,

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

Doug,

"KenSheridan via AccessMonster.com" wrote:

> 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
>
> Doug wrote:
> >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?
>
> --
> Message posted via [URL="http://www.accessmonster.com"]http://www.accessmonster.com[/URL]
>
> .
>
 >> Stay informed about: Hpw can I use the same label format?