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_Label" 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 3 1770
-----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!frmPrintJob!txtDestination
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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQlCCdYechKqOuFEgEQLmOACgljJLV5S+cOR5goYSImRbuX FrSp0AoNUF
aPUQF5MMh6qV0G1MIoA77c9g
=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_Label" 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.
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" <me@privacy.com> wrote in message
news:so*****************@newsread2.news.pas.earthl ink.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!frmPrintJob!txtDestination
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:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA)
-----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv
iQA/AwUBQlCCdYechKqOuFEgEQLmOACgljJLV5S+cOR5goYSImRbuX FrSp0AoNUF aPUQF5MMh6qV0G1MIoA77c9g =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_Label" 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.
-----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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQlCtoIechKqOuFEgEQIMkQCfdR1WLHq9aMEP0pmyeJnkUk 2zf5kAoKXf
rw8xt8FCGm5jtPx7mjYQ9NUl
=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" <me@privacy.com> wrote in message news:so*****************@newsread2.news.pas.earthl ink.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!frmPrintJob!txtDestination
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:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA)
-----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv
iQA/AwUBQlCCdYechKqOuFEgEQLmOACgljJLV5S+cOR5goYSImRbuX FrSp0AoNUF aPUQF5MMh6qV0G1MIoA77c9g =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_Label" 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Paul Mendez |
last post by:
I have a form that consists of 150 records and is still growing.
there are times when I want to print a certain record of the form, say
record 12. I go to file --> print and choose the page number...
|
by: ken |
last post by:
I had to reinstall Windows 2000 Pro and of course Access 2000. I HAD
each record displaying a photo but now it does not show them. The
WEIRD thing is that when I upload the database to my...
|
by: Greg |
last post by:
I'm fairly new to access (using 2002) and am setting up a DB for work.
along with each record the user also needs to make a flow diagram
(previously, these reports were composed in word and they...
|
by: Mike Conklin |
last post by:
This one really has me going. Probably something silly. I'm using
dcount for a report to determine the number of different types of
tests proctored in a semester.
My report is based on a...
|
by: Hers2keep |
last post by:
I have a report that prints daily. The report needs to print whether or
not there are records available. I read in an old post on this group
that putting an unbound text box in the report footer,...
|
by: buck |
last post by:
reports/ can we alternate formatting such as "no shading" and then
"shading" for multiple records such as a phone directory in Access2000
reports
|
by: Wadim Grasza |
last post by:
I want to store and display (on a form or a report) multiple pictures
per
record in an access database. The pictures are not stored within the
database. They are stored as files and the database...
|
by: John Smith |
last post by:
Hello, I have 7 different crystal reports that need to be collated.
Since I want to end up with a page of each (which all together make a
single report), I created a blank main report and then...
|
by: johkar |
last post by:
I need some browser implementation clarification.
In the below example, the alternate stylesheet could be invoked by
user agents that support alternate stylesheets or by script. Are
there any...
|
by: Bad Horsey |
last post by:
Windows XP
MS Access 2000
Hello folks. First timer here. Have a problem with a form.
I am trying to open a report using a button on a form. The report will use information from a table...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |