Sabtu, 10 September 2011

RE: [MS_AccessPros] How to Print Multiple Labels?

If the CountID is 8, there will be 8 records in the tblNums <= 8 so there will be 8 of the same label record. The CountID will determine the number of "copies" of the record that get returned in the record source. You would not JOIN tblNums to any table in the query.

Duane Hookom
MS Access MVP

> To: MS_Access_Professionals@yahoogroups.com
> From: classon@aol.com
> Date: Sat, 10 Sep 2011 13:56:51 -0400
> Subject: Re: [MS_AccessPros] How to Print Multiple Labels?
>
> Duane,
>
> Not sure that will work as she wants a different label count depending on the record. OR did I misunderstand?
>
> Thanks,
> Gina Whipp
> 2010 - 2011 Microsoft MVP (Access)
>
> www.access-diva.com
>
>
> From: Duane Hookom
> Sent: Saturday, September 10, 2011 1:20 PM
> To: Access Professionals Yahoo Group
> Subject: RE: [MS_AccessPros] How to Print Multiple Labels?
>
>
> Create a table of numbers tblNums with a single, numeric field [Num] and add records with values 1 through some large number. Add this table to your report's record source and set the criteria under the [Num] field to:
> <=[CountID]
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: m.statalex@yahoo.com
> Date: Sat, 10 Sep 2011 11:41:14 +0000
> Subject: Re: [MS_AccessPros] How to Print Multiple Labels?
>
>
>
>
>
>
> Hi Gina,
>
> You are so close to what I need. I did as you mentioned and it worked, but still there is one more code missing, I guess. Also, I created a continuous form to be able to enter the number of labels I want to print for each record I select. I first created the CountID field in my table, then I created the form so it becomes easy for the user to input how many labels to print per each record. Then I created the Labels report. I entered, for example, 5 for first record and 3 for the second one and left all other records (CountID field) empty. It printed correctly for the 2 records but printed also an infinite number of labels for the rest of records.
>
> I thought if I put default value of CountId field to be zero then change the value as I need to print the labels I want. When I did that, I got a runtime error message and report did not show up. The runtime error '11': Division by zero and I clicked on Debug, the line If intLabelCount Mod [CountID] = 0 Then was shaded yellow. What do you think I can do here?
>
> Excuse me for my many questions, I am still learning Access and I enjoy learning so much.
>
> Thank you for the great help you provide.
>
> Marwa
>
> --- In MS_Access_Professionals@yahoogroups.com, "Gina Whipp" <classon@...> wrote:
> >
> > 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]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar