Kumar,
In this context, my sample db named Report_PrintLabelsCustomStart might also be of interest to you. It is in access 2000 file format and is available at Rogers Access Library. Link:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
This sample db demonstrates two alternative methods for printing of labels in such a manner that starting position of first label as well as different number of copies for each label can be specified by the user. Out of available source data, only the labels selected by user will actually get printed.
For ready reference, brief description is placed below.
Best wishes,
A.D. Tejpal
------------
Report_PrintLabelsCustomStart (Sample Db)
Brief Description:
===============================
This sample db demonstrates printing of labels in such a manner that starting position of first label as well as different number of copies for each label can be specified by the user. Out of available source data, only the labels selected by user will actually get printed. The report used for this demo has three columns.
Two methods are covered as follows:
(a) Everything is managed via VBA code. No interference to report's record source is needed.
(b) The query serving as report's record source is devised in such a manner that it takes care of specified start position for first label to be printed as well as different number of copies for each label as desired. VBA code is minimal - just for hiding the control when label is blank.
Method (b) above makes use of driver table T_Ref having a single field RefNum populated with numbers 1 to 200. If the number of copies for any label are likely to exceed this number, contents of table T_Ref can be expanded suitably.
Source data consisting of three fields holding top middle and bottom lines for the intended label, is displayed in a subform along with a column displaying the desired number of copies in each case. The last column has bound check boxes enabling the user to select which of the labels are to be printed.
Sample label pertaining to current record in the subform is displayed on the parent form. Any editing of contents in the subform gets reflected promptly in the sample label.
Version: Access 2000 file format.
===============================
----- Original Message -----
From: access_kri
To: MS_Access_Professionals@yahoogroups.com
Sent: Sunday, November 27, 2011 08:00
Subject: [MS_AccessPros] Re: Printing Multiple labels- different number of labels for each record
Thanks, John.
I understood your methodology and tried it but it is not working. I am explaining what I did, please let me know where I am doing wrong.
I created a simple table T_labelQty with numbers 1,2,3 etc. as rows. I then created a query including the table T_labelQty and my original table T_POLabels without join and the set the criteria for LabelQty as <=[DeliveredQty]. However, I am not getting the number of rows in the query equal to delivered quantities. Why?
Regards,
Kumar
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Kumar-
>
> You can find some code examples on the Microsoft website that involve preventing
> the report from advancing to a new record "n" times. But my preferred method is
> to create a simple table with one Integer field. Create rows in the table with
> each row containing a different number from 1 to the max number of labels you
> want to produce. For your report record source, include that table in the query
> with no joins to any table. Add the number field to the query grid and add
> criteria like:
>
> <=[Quantity]
>
> That will generate multiple rows for each detail item up to the quantity
> ordered, which will then print "n" labels per product.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
> Sent: Saturday, November 26, 2011 6:28 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Printing Multiple labels- different number of labels
> for each record
>
> Dear group,
> I have developed MS Access2000 database for Goods receipts. As the order
> quantities may be different for different line items (records), I want to print
> multiple labels for each record based on the order quantities. In my T_POlabels
> (on which the label report is based), I have a field indicating the number of
> labels required for each record.
> How do I get the desired multiple labels for each record when I print the
> report. Please advise.
>
> Kind Regards,
> Kumar
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar