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

Jumat, 09 September 2011

RE: [MS_AccessPros] How to Print Multiple Labels?

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@yahoo.com
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]
>