Marwa,
Okay, I think I got something for you. You need a field in your table that will store the quantity of labels per record. For my example I called it CountID. Then set up your Label Report and put CountID on the report in the Detail section making in invisible. Then in the Detail On_Print section put...
Static intLabelCount As Integer
intLabelCount = intLabelCount + 1
If intLabelCount Mod [CountID] = 0 Then
Me.NextRecord = True
intLabelCount = 0
Else
Me.NextRecord = False
End If
Thanks,
Gina Whipp
2010 - 2011 Microsoft MVP (Access)
www.access-diva.com
From: Gina Whipp
Sent: Friday, September 09, 2011 9:38 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] How to Print Multiple Labels?
Marwa,
Oh I am sure there is a way but no one that I have ever done.
Thanks,
Gina Whipp
2010 - 2011 Microsoft MVP (Access)
www.access-diva.com
From: Marwa Abo Amra
Sent: Friday, September 09, 2011 5:45 PM
To: mailto:MS_Access_Professionals%40yahoogroups.com
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 mailto:MS_Access_Professionals%40yahoogroups.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: mailto:MS_Access_Professionals%40yahoogroups.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