Shipping Labels

[klp via AccessMonster.com]

I am creating a form that the shipping labels will print from. However I am a
little stuck. Below I will try to explain my form.

On the main part of the form I will have a combo box, this is where the user
will be able to select an order. The subform will then bring up the details
for that order(LineNo & ItemNo). Here I added a field Label Count. I need the
user to be able to go into each line and depict how many labels for EACH line.
Then Print the shipping labels based on how many labels for each of those
part numbers. For example:

Order ID: 1451

Line Item # Label Cnt
1 123456 2
2 789101 1
3 987654 0

So then when the shipping labels print it will print 2 of item # 123456 and 1
of 789101. How do I go about doing this?

any help greatly appreciated.

 

[Allen Browne]

See:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

 

[strive4peace]

the "cheapest" way to do this is to create a table with, for instance,
the numbers 1-50 (or whatever is the maximum number of labels you will
allow)

Qtys
Qty

records are

Qty
1
2
3
etc

in a query: use your table and the Qtys table as fieldlists

put the items you want printed on the grid and then, this also:

field --> Qty
table --> Qtys
show --> no
criteria --> <= QtyToPrint


This will cause Access to create the label information multiple times in
the underlying recordset


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[klp via AccessMonster.com]

Okay your reply was kind of the same as the other reply I got. I have done
that to other labels that I need printed and it has worked for them. However,
when I click on my preview button, it will give me the QtyToPrint, I put in 5.
Okay fine, it prints 5. Problem is that I may need to print a total of 5
labels, but 2 got to part number 123456, 2 to part number 7891012 and 1 to
part 987654. How can I do that? I want them to be able on the form end of it,
physically type in as stated above for each line if that's what they need.
Then when I select the print button it will print 2 for 123456, 2 for 7891012
and 1 for 987654.

the "cheapest" way to do this is to create a table with, for instance,
the numbers 1-50 (or whatever is the maximum number of labels you will
allow)

Qtys
Qty

records are

Qty
1
2
3
etc

in a query: use your table and the Qtys table as fieldlists

put the items you want printed on the grid and then, this also:

field --> Qty
table --> Qtys
show --> no
criteria --> <= QtyToPrint

This will cause Access to create the label information multiple times in
the underlying recordset

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

I am creating a form that the shipping labels will print from. However I am a
little stuck. Below I will try to explain my form.

[quoted text clipped - 17 lines]

any help greatly appreciated.

 

[John Vinson]

Okay your reply was kind of the same as the other reply I got. I have done
that to other labels that I need printed and it has worked for them. However,
when I click on my preview button, it will give me the QtyToPrint, I put in 5.
Okay fine, it prints 5. Problem is that I may need to print a total of 5
labels, but 2 got to part number 123456, 2 to part number 7891012 and 1 to
part 987654. How can I do that? I want them to be able on the form end of it,
physically type in as stated above for each line if that's what they need.
Then when I select the print button it will print 2 for 123456, 2 for 7891012
and 1 for 987654.

You'll need a LabelQuantity field in the Parts table so that each part
records its own quantity. In the Query that Crystal suggests, just use
the LabelQuantity field as a criterion rather than referring to the
form.

John W. Vinson[MVP]

 

[klp via AccessMonster.com]

Okay, I had started to do that before you replied. My question remains though,
when I select my order, click on preview the query will be in effect and
bring up a dialog box [QtyToPrint], if I put in 5, it just prints 5 labels.
Can I have a box come up saying QtyToPrint for part # 123456, then enter in 2.
Another box come up and say QtyToPrint for part #7891012, and finally
QtyToPrint for part #987654?

Okay your reply was kind of the same as the other reply I got. I have done
that to other labels that I need printed and it has worked for them. However,

[quoted text clipped - 5 lines]

Then when I select the print button it will print 2 for 123456, 2 for 7891012
and 1 for 987654.

You'll need a LabelQuantity field in the Parts table so that each part
records its own quantity. In the Query that Crystal suggests, just use
the LabelQuantity field as a criterion rather than referring to the
form.

John W. Vinson[MVP]

 

[klp via AccessMonster.com]

I had another question - If it's in the parts # table, which I prefer it not
to be in due to other complications is can cause, then would I be able to
change the qty for that part number if I am not going to refer to the form? I
was trying to put it in the orderlines table, which will be more realistic
and convenient rather the parts table.

Okay, I had started to do that before you replied. My question remains though,
when I select my order, click on preview the query will be in effect and
bring up a dialog box [QtyToPrint], if I put in 5, it just prints 5 labels.
Can I have a box come up saying QtyToPrint for part # 123456, then enter in 2.
Another box come up and say QtyToPrint for part #7891012, and finally
QtyToPrint for part #987654?
[quoted text clipped - 8 lines]

John W. Vinson[MVP]

 

[strive4peace]

What determines how many labels will print?
How many different parts do you handle?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

I had another question - If it's in the parts # table, which I prefer it not
to be in due to other complications is can cause, then would I be able to
change the qty for that part number if I am not going to refer to the form? I
was trying to put it in the orderlines table, which will be more realistic
and convenient rather the parts table.

Okay, I had started to do that before you replied. My question remains though,
when I select my order, click on preview the query will be in effect and
bring up a dialog box [QtyToPrint], if I put in 5, it just prints 5 labels.
Can I have a box come up saying QtyToPrint for part # 123456, then enter in 2.
Another box come up and say QtyToPrint for part #7891012, and finally
QtyToPrint for part #987654?

Okay your reply was kind of the same as the other reply I got. I have done
that to other labels that I need printed and it has worked for them. However,

[quoted text clipped - 8 lines]

John W. Vinson[MVP]

 

[klp via AccessMonster.com]

We handle as many as 18000 parts. Again, on my form I will be able to select
the order that I want. When I select that order it will then bring up in a
subform, all the line detail that go with that order(there can be several
lines per order). So with that said, I would like the user to go into each
line and have them depict how many labels they want per line. Sorry I know
this is hard and explaining isn't that easy so bare with me. Anyway, they
don't always need to do that either. Sometimes they will go in and just put
in 4 labels for the very first line. As I descibed below in an example:

Selected order #.
Order ID: 1451

Line Part # Label Cnt (This will show on the form
where they will depict the # of
1 123456 2 labels for each part #)
2 789101 1
3 987654 0

So once they've told the system how many labels they want to print, they will
click on the preview button for shipping labels and it will print 2 of item #
123456 and 1of 789101.
The shipping label output would be something of the following:

customer 10 part # 123456
01/23/07
customer 10 part # 123456
01/23/07
customer 10 part # 789101
01/23/07

Hope this helps, sorry for all the confusion...

What determines how many labels will print?
How many different parts do you handle?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

I had another question - If it's in the parts # table, which I prefer it not
to be in due to other complications is can cause, then would I be able to

[quoted text clipped - 13 lines]

[quoted text clipped - 8 lines]
John W. Vinson[MVP]

 

[John Vinson]

I had another question - If it's in the parts # table, which I prefer it not
to be in due to other complications is can cause, then would I be able to
change the qty for that part number if I am not going to refer to the form? I
was trying to put it in the orderlines table, which will be more realistic
and convenient rather the parts table.

Well... put it in whatever table makes sense. You know that much
better than I.

In any case, you should NOT be getting a prompt if you simply include
Crystal's numbers-table in the query, with no join line; put the
appropriate number-of-labels field as a criterion on the number field,
preceded by a < sign.

John W. Vinson[MVP]

 

[strive4peace]

Hi klp (what is your name?)

do the number of labels correspond to ANYTHING that is stored? If not,
then it makes sense to add a LabelCnt field to the table with the labels
-- make the DefaultValue=Null

then add this field to your entry form as well

and also add this field to the report RecordSource

that way, if there is no value specified, you can use whatever the user
has entered on the form for a general default.

field --> Qty
table --> Qtys
criteria --> <=IIf(IsNull([LabelCnt]),1,[LabelCnt])

where
1 is the Default value

this can also be a control reference -->
forms!formname!controlname

btw, do not use spaces or special characters (such as #) in fieldnames
(they bite!) ... underscore _ is ok...


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

We handle as many as 18000 parts. Again, on my form I will be able to select
the order that I want. When I select that order it will then bring up in a
subform, all the line detail that go with that order(there can be several
lines per order). So with that said, I would like the user to go into each
line and have them depict how many labels they want per line. Sorry I know
this is hard and explaining isn't that easy so bare with me. Anyway, they
don't always need to do that either. Sometimes they will go in and just put
in 4 labels for the very first line. As I descibed below in an example:

Selected order #.
Order ID: 1451

Line Part # Label Cnt (This will show on the form
where they will depict the # of
1 123456 2 labels for each part #)
2 789101 1
3 987654 0

So once they've told the system how many labels they want to print, they will
click on the preview button for shipping labels and it will print 2 of item #
123456 and 1of 789101.
The shipping label output would be something of the following:

customer 10 part # 123456
01/23/07
customer 10 part # 123456
01/23/07
customer 10 part # 789101
01/23/07

Hope this helps, sorry for all the confusion...

What determines how many labels will print?
How many different parts do you handle?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

I had another question - If it's in the parts # table, which I prefer it not
to be in due to other complications is can cause, then would I be able to

[quoted text clipped - 13 lines]

[quoted text clipped - 8 lines]
John W. Vinson[MVP]

 

[klp via AccessMonster.com]

Thank you, thank you, thank you! That worked perfectly! My name is Kim btw.

Hi klp (what is your name?)

do the number of labels correspond to ANYTHING that is stored? If not,
then it makes sense to add a LabelCnt field to the table with the labels
-- make the DefaultValue=Null

then add this field to your entry form as well

and also add this field to the report RecordSource

that way, if there is no value specified, you can use whatever the user
has entered on the form for a general default.

field --> Qty
table --> Qtys
criteria --> <=IIf(IsNull([LabelCnt]),1,[LabelCnt])

where
1 is the Default value

this can also be a control reference -->
forms!formname!controlname

btw, do not use spaces or special characters (such as #) in fieldnames
(they bite!) ... underscore _ is ok...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

We handle as many as 18000 parts. Again, on my form I will be able to select
the order that I want. When I select that order it will then bring up in a

[quoted text clipped - 46 lines]

[quoted text clipped - 8 lines]
John W. Vinson[MVP]

 

[strive4peace]

you're welcome, Kim happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Thank you, thank you, thank you! That worked perfectly! My name is Kim btw.

Hi klp (what is your name?)

do the number of labels correspond to ANYTHING that is stored? If not,
then it makes sense to add a LabelCnt field to the table with the labels
-- make the DefaultValue=Null

then add this field to your entry form as well

and also add this field to the report RecordSource

that way, if there is no value specified, you can use whatever the user
has entered on the form for a general default.

field --> Qty
table --> Qtys
criteria --> <=IIf(IsNull([LabelCnt]),1,[LabelCnt])

where
1 is the Default value

this can also be a control reference -->
forms!formname!controlname

btw, do not use spaces or special characters (such as #) in fieldnames
(they bite!) ... underscore _ is ok...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

We handle as many as 18000 parts. Again, on my form I will be able to select
the order that I want. When I select that order it will then bring up in a

[quoted text clipped - 46 lines]

[quoted text clipped - 8 lines]
John W. Vinson[MVP]