Hpw can I use the same label format?

[Doug]

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?

 

[Tom Wickerath]

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/
__________________________________________

 

[Doug]

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.

 

[Doug]

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]

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]

You're welcome. Glad you got it working!


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

 

[Tom Wickerath]

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/
__________________________________________

 

[Doug]

Good evening Ken,

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

Doug,