ACCESS FEED: RE: [MS_AccessPros] How to Print Multiple Labels?

Jumat, 09 September 2011

RE: [MS_AccessPros] How to Print Multiple Labels?

What did you do? Did you create a table consisting of the primary key values and number of labels to print for each label?

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: m.statalex@yahoo.com
Date: Sat, 10 Sep 2011 00:23:18 +0000
Subject: Re: [MS_AccessPros] How to Print Multiple Labels?

Hi Duane

I already tried it, but when i did it I got a label report that has all the records printed 10 times each. I set the maximum number of labels to be 10. I need to be able to select only the records that I want to print and set the number of labels per each record. Then I need them to show on the report together so I can print them.

I really need help in this!

Thanks,

Marwa

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> I would use Allen Browne's solution found at http://www.allenbrowne.com/ser-39.html. This assumes you store the number of labels in the records.
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: m.statalex@...
> Date: Fri, 9 Sep 2011 21:45:43 +0000
> Subject: Re: [MS_AccessPros] How to Print Multiple Labels?
>
>
>
>
>
>
>
> Gina,
>
> Thank you so much. It is really good one. But in my project, I need to be able to choose some records and specify the number of labels I want to print then I can print all of them at once. For example, I need to select record number 3, 10, 52, 120, ... etc and specify number of labels for each record like 2, 3, 5, 2, 10,...etc. Then I preview all in one report and print them at once. Is there any way to do that?..
>
> I appreciate any help.
>
> Marwa
>
> --- In MS_Access_Professionals@yahoogroups.com, "Gina Whipp" <classon@> wrote:
> >
> > oops... link didnâ€™t come thru...
> >
> > http://www.access-diva.com/r1.html
> >
> > Thanks,
> > Gina Whipp
> > 2010 - 2011 Microsoft MVP (Access)
> >
> > www.access-diva.com
> >
> >
> > From: Marwa Abo Amra
> > Sent: Friday, September 09, 2011 2:24 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] How to Print Multiple Labels?
> >
> >
> > I need a code or a method to use to be able to print one or more labels; knowing that I need to print at least 1 copy of each record I choose all at once.
> >
> > I found a way to do so in this link: http://www.techrepublic.com/blog/msoffice/how-to-print-multiple-labels-for-a-single-record-in-access/872
> >
> > I used the steps shown under the title: Print one or more labels for one or more records
> >
> > When I followed the steps shown there, I got some compile errors and looks like the code was not really correct.
> >
> > May anyone help me in doing this? I would really appreciate any ideas.
> >
> > Thank you all!
> >
> > Marwa
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>