Alternate Record Printing Between 2 Reports

[ChadDiesel]

I've been posting questions here the last week, but if you don't know my
situation:

I have a "Print Labels" button on the subform that sends the appropriate box
information on the subform to a report called "Labels." This is how we are
going to print our shipping labels. I also have a label which is a report
called "Destination_La bel" that contains the address where the shipment is
to be delivered. While each box label in the "Label" report is unique, the
destination label is the same for all the boxes in that shipment.

What I would like to do is print 2 copies of the box label and 1 copy of the
destination label in that order. For example, if I have 3 boxes on my
subform, I would like press a button that would cause the labels to print
like this:

Box Label 1, Box Label 1, Destination Label, Box Label 2, Box Label 2,
Destination Label, Box Label 3, Box Label 3, Destination Label

We print a lot of labels and it would be easier to apply the labels in order
instead of dealing with 2 stacks of labels. Again, each box label is unique,
but the destination label is the same for the entire shipment.

Is something like this possible? Help would be greatly appreciated.

Thanks,

Chad

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Set up the report to have a group section for recipients. Make the
recipients group footer visible and put a TextBox control in it. Set
that control's ControlSource property to a TextBox on the form that
starts the print job. The form's TextBox will have the Destination
address. The ControlSource would look like this:

Control Source: =Forms!frmPrint Job!txtDestinat ion

Or you can use many TextBoxes to get Destination Address, City, State,
Postal Code, etc. Just use the same principle: Report's TextBoxes
Control Source points to the form's Destination info TextBoxes.

You have to play w/ the positioning of the Destination Text Box on the
report so it prints in the correct position on the label strip.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlCCdYechKq OuFEgEQLmOACglj JLV5S+cOR5goYSI mRbuXFrSp0AoNUF
aPUQF5MMh6qV0G1 MIoA77c9g
=jrt4
-----END PGP SIGNATURE-----

ChadDiesel wrote:

I've been posting questions here the last week, but if you don't know my
situation:

I have a "Print Labels" button on the subform that sends the appropriate box
information on the subform to a report called "Labels." This is how we are
going to print our shipping labels. I also have a label which is a report
called "Destination_La bel" that contains the address where the shipment is
to be delivered. While each box label in the "Label" report is unique, the
destination label is the same for all the boxes in that shipment.

What I would like to do is print 2 copies of the box label and 1 copy of the
destination label in that order. For example, if I have 3 boxes on my
subform, I would like press a button that would cause the labels to print
like this:

Box Label 1, Box Label 1, Destination Label, Box Label 2, Box Label 2,
Destination Label, Box Label 3, Box Label 3, Destination Label

We print a lot of labels and it would be easier to apply the labels in order
instead of dealing with 2 stacks of labels. Again, each box label is unique,
but the destination label is the same for the entire shipment.

Is something like this possible? Help would be greatly appreciated.

[ChadDiesel]

Hello,

Thanks for responding, here is a picture of my labels:

http://www.chadworld.com/images/labels.jpg

and here is a picture of my form:

http://www.chadworld.com/images/form.jpg

I should have mentioned that there are only 4 locations (right now) that we
ship, so in the form, if you select San Diego as the destination, I have
query that feeds the destination label report. I have it set up so when you
hit the button on the subform, it prints the records only on the subform.
How would I print 2 labels then the destination in the correct order? I
don't quite follow you. Please bare with me as I am very new to access and
am trying to figure out things as I go.

Thanks,

Chad
"MGFoster" <[e-mail] > wrote in message
news:so******** *********@newsr ead2.news.pas.e arthlink.net...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Set up the report to have a group section for recipients. Make the
recipients group footer visible and put a TextBox control in it. Set
that control's ControlSource property to a TextBox on the form that
starts the print job. The form's TextBox will have the Destination
address. The ControlSource would look like this:

Control Source: =Forms!frmPrint Job!txtDestinat ion

Or you can use many TextBoxes to get Destination Address, City, State,
Postal Code, etc. Just use the same principle: Report's TextBoxes
Control Source points to the form's Destination info TextBoxes.

You have to play w/ the positioning of the Destination Text Box on the
report so it prints in the correct position on the label strip.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlCCdYechKq OuFEgEQLmOACglj JLV5S+cOR5goYSI mRbuXFrSp0AoNUF
aPUQF5MMh6qV0G1 MIoA77c9g
=jrt4
-----END PGP SIGNATURE-----

ChadDiesel wrote:

I've been posting questions here the last week, but if you don't know my
situation:

I have a "Print Labels" button on the subform that sends the appropriate
box
information on the subform to a report called "Labels." This is how we
are
going to print our shipping labels. I also have a label which is a report
called "Destination_La bel" that contains the address where the shipment
is
to be delivered. While each box label in the "Label" report is unique,
the
destination label is the same for all the boxes in that shipment.

What I would like to do is print 2 copies of the box label and 1 copy of
the
destination label in that order. For example, if I have 3 boxes on my
subform, I would like press a button that would cause the labels to print
like this:

Box Label 1, Box Label 1, Destination Label, Box Label 2, Box Label 2,
Destination Label, Box Label 3, Box Label 3, Destination Label

We print a lot of labels and it would be easier to apply the labels in
order
instead of dealing with 2 stacks of labels. Again, each box label is
unique,
but the destination label is the same for the entire shipment.

Is something like this possible? Help would be greatly appreciated.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Read the Access Help articles on "Sorting and Grouping Records on a
Report" and it's subcategories.

OR (a better idea)

You could set up a report that just has the Destination address in the
Details section and w/ a subreport that has the recipients address info.
Read the Access Help articles "Create a subreport." It's just like a
subform.

IOW, something like this on the report:

Detail section
=============== =========
Destination address
+--------------------+
| (subform) |
| Packing label 1 |
| Packing label 2 |
| <others labels> |
+--------------------+
=============== =========
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlCtoIechKq OuFEgEQIMkQCfdR 1WLHq9aMEP0pmye JnkUk2zf5kAoKXf
rw8xt8FCGm5jtPx 7mjYQ9NUl
=68z5
-----END PGP SIGNATURE-----

ChadDiesel wrote:

Hello,

Thanks for responding, here is a picture of my labels:

http://www.chadworld.com/images/labels.jpg

and here is a picture of my form:

http://www.chadworld.com/images/form.jpg

I should have mentioned that there are only 4 locations (right now) that we
ship, so in the form, if you select San Diego as the destination, I have
query that feeds the destination label report. I have it set up so when you
hit the button on the subform, it prints the records only on the subform.
How would I print 2 labels then the destination in the correct order? I
don't quite follow you. Please bare with me as I am very new to access and
am trying to figure out things as I go.

Thanks,

Chad
"MGFoster" <[e-mail] > wrote in message
news:so******** *********@newsr ead2.news.pas.e arthlink.net...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Set up the report to have a group section for recipients. Make the
recipients group footer visible and put a TextBox control in it. Set
that control's ControlSource property to a TextBox on the form that
starts the print job. The form's TextBox will have the Destination
address. The ControlSource would look like this:

Control Source: =Forms!frmPrint Job!txtDestinat ion

Or you can use many TextBoxes to get Destination Address, City, State,
Postal Code, etc. Just use the same principle: Report's TextBoxes
Control Source points to the form's Destination info TextBoxes.

You have to play w/ the positioning of the Destination Text Box on the
report so it prints in the correct position on the label strip.

--
MGFoster:::mg f00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlCCdYechKq OuFEgEQLmOACglj JLV5S+cOR5goYSI mRbuXFrSp0AoNUF
aPUQF5MMh6qV0 G1MIoA77c9g
=jrt4
-----END PGP SIGNATURE-----

ChadDiesel wrote:

I've been posting questions here the last week, but if you don't know my
situation:

I have a "Print Labels" button on the subform that sends the appropriate
box
informatio n on the subform to a report called "Labels." This is how we
are
going to print our shipping labels. I also have a label which is a report
called "Destination_La bel" that contains the address where the shipment
is
to be delivered. While each box label in the "Label" report is unique,
the
destinatio n label is the same for all the boxes in that shipment.

What I would like to do is print 2 copies of the box label and 1 copy of
the
destinatio n label in that order. For example, if I have 3 boxes on my
subform, I would like press a button that would cause the labels to print
like this:

Box Label 1, Box Label 1, Destination Label, Box Label 2, Box Label 2,
Destinatio n Label, Box Label 3, Box Label 3, Destination Label

We print a lot of labels and it would be easier to apply the labels in
order
instead of dealing with 2 stacks of labels. Again, each box label is
unique,
but the destination label is the same for the entire shipment.

Is something like this possible? Help would be greatly appreciated.