Hello Duane,
I created a table consisting of one field as mentioned in the web page. That field contains number of labels per each record. I followed the steps shown in http://www.allenbrowne.com/ser-39.html
But it printed all the records and all numbers of labels. I couldn't specify if I want to print 3 labels of that record, 2 labels of another record, 5 labels of a third record,... and so on.
I am sure there is something I should do but I can't figure it out.
I appreciate your help!
M
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> 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@...
> 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]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar