from a FORM print a label report 3 labels per sheet for CURRENT re

reposted since I haven't gotten an answer
ONE MORE thing- yeah sure.

I tried the max for the RecID to only print out the last record. It prints
the last record entered but not really what I want. On the form I would
acutally like if they press the PRINT LABEL button for it to print 3 copies
of the label-really 1sheet for that SPECIFIC record that is currently
visible????? not always the last record entered.

Please help asap -needed this done yesterday of course????
Thanks,
barb

"babs" wrote:

Sorry one more thing when I press the print label command button with the
code below. It also prints every record in the current form I am on. I only
want the label report to print NOT the FORM record(s)
Thanks

"babs" wrote:

This works but it prints every record 3x. I only want it to print a report-
a label 3x same sheet for the ONE record that is currently displayed on the
form. I am using the textbox where the #labels defaults to 3. or they can
put own in obviously.

Thanks for your help,
Barb

" wrote:

hi again,
I told you wrong.
for three lables each time do this

Docmd.OpenReport "yourlabelreport", acviewnormal
DoCmd.PrintOut , , , , 3

the second way is still valid
sorry about that.
good luck

-----Original Message-----
hi again,
been a while. i almost forgot.
yes the button click event.
if you want 3 labels to print each time all the time then

Docmd.OpenReport "yourlabelreport", acviewnormal
Docmd.OpenReport "yourlabelreport", acviewnormal
Docmd.OpenReport "yourlabelreport", acviewnormal

there is a another way. by putting a text box on the form
for the number of labels to print. you could default it
to
3.

Docmd.OpenReport "yourlabelreport", acviewnormal
DoCmd.PrintOut , , , , Me.txtQtyToPrint

but the last way may require input and is best if you
need
to print different numbers of labels each time.

At some point the printer comes in to do the label feed.
access don't do that part.
good luck

-----Original Message-----
thanks for the input, I do have an autonumber field and
I
can do the max to
that. for the print out 3x I have used VB but not a ton-
do I tie an event
procured to the on click of the command button and what
would the Print code
say to get 3 labels on the same sheet( 3label sheet)and
not 1 label per sheet
3x

Thanks,
barb

" wrote:

hi,
if you are not using a query to select the last
record,
the the report will try to print the whole table.
Product code
mfg date
lot#
r'cved date
I see not record number. If r'cved date has at time
stamp,
you could use max r'cved date. but this might cause
you
to
write 2 queries.(why? cant use group by with Max)first
query would select the max r'cved date first query
would
be used in the second guery to select all field
matching
the Max r'cved date.
the second query would be the report's record source.
If r'cved date does not have a time stamp, then you
should
consider a record number. and select max record
number.
the 2 queries would prevent a parameter query.
to print 3 times add code to print 3 times.
hope this helps

-----Original Message-----
I want production to enter into a form the product
code,
manufactured date,
lot#, received date - where the lot# and received
date
together make the
record unique. I created a label report based on
this
form but want them to
be able to print out the labels only for the newest
record that they entered
in. I added a command button that previews the
report
but it shows ALL
records and I only want the most recent record
printed
out. I also would like
the label to be repeated 3X on the one sheet - 3
labels/page. Right now I
have the 3 labels per page but they are all three
different labels for each
record - I would like them to be all the same. I
know
I
could add a
parameter query to the report but that would make
them
reenter data. any way
to get around this.

Thanks,
Barb

See:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

And:
Printing a Quantity of a Label
at:
http://members.iinet.net.au/~allenbrowne/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"babs" wrote in message
...
reposted since I haven't gotten an answer
ONE MORE thing- yeah sure.

I tried the max for the RecID to only print out the last record. It prints
the last record entered but not really what I want. On the form I would
acutally like if they press the PRINT LABEL button for it to print 3
copies
of the label-really 1sheet for that SPECIFIC record that is currently
visible????? not always the last record entered.

Please help asap -needed this done yesterday of course????
Thanks,
barb

I tried this and it will only print the newest record entered. I would like
if the user navigates through the form that whatever record is in focus and
they press the print command button that label should be printed. Right now
only the last record entered looks okay on the label and I get errors when I
go to any other record.

Please help asap - of course I need this by Monday
Thanks,
Barb

"Allen Browne" wrote:

See:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

And:
Printing a Quantity of a Label
at:
http://members.iinet.net.au/~allenbrowne/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"babs" wrote in message
...
reposted since I haven't gotten an answer
ONE MORE thing- yeah sure.

I tried the max for the RecID to only print out the last record. It prints
the last record entered but not really what I want. On the form I would
acutally like if they press the PRINT LABEL button for it to print 3
copies
of the label-really 1sheet for that SPECIFIC record that is currently
visible????? not always the last record entered.

Please help asap -needed this done yesterday of course????
Thanks,
barb

Make sure your form contains a field for the primary key. Set its visible
property to False. Create a table named TblNumbers with one field named
Number. Enter 1, 2 and 3 into the table. Base your label report on a query.
Be sure to include the primary key (same primary key as your form). Add
TblNumbers to your query. There will be no join line! Put the following
expression in the criteria of the primary key:
Forms!NameOfYourForm!NameOfPrimaryKeyTextbox

When you press the print command button, you will get three labels for the
current record on your form.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"babs" wrote in message
...
I tried this and it will only print the newest record entered. I would
like
if the user navigates through the form that whatever record is in focus
and
they press the print command button that label should be printed. Right
now
only the last record entered looks okay on the label and I get errors when
I
go to any other record.

Please help asap - of course I need this by Monday
Thanks,
Barb

"Allen Browne" wrote:

See:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

And:
Printing a Quantity of a Label
at:
http://members.iinet.net.au/~allenbrowne/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"babs" wrote in message
...
reposted since I haven't gotten an answer
ONE MORE thing- yeah sure.

I tried the max for the RecID to only print out the last record. It
prints
the last record entered but not really what I want. On the form I
would
acutally like if they press the PRINT LABEL button for it to print 3
copies
of the label-really 1sheet for that SPECIFIC record that is currently
visible????? not always the last record entered.

Please help asap -needed this done yesterday of course????
Thanks,
barb

will this make sure that only the current record - on that they have entered
OR NAVIGATED TO WILL BE THE RECORD THAT THE LABEL REPORT GETS PRINTED FOR. I
also would like them to be able to put in there own quantity of labels with
the default of 3. Need this done by Monday morning. Thanks for helping.

Barb

"PC Datasheet" wrote:

Make sure your form contains a field for the primary key. Set its visible
property to False. Create a table named TblNumbers with one field named
Number. Enter 1, 2 and 3 into the table. Base your label report on a query.
Be sure to include the primary key (same primary key as your form). Add
TblNumbers to your query. There will be no join line! Put the following
expression in the criteria of the primary key:
Forms!NameOfYourForm!NameOfPrimaryKeyTextbox

When you press the print command button, you will get three labels for the
current record on your form.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"babs" wrote in message
...
I tried this and it will only print the newest record entered. I would
like
if the user navigates through the form that whatever record is in focus
and
they press the print command button that label should be printed. Right
now
only the last record entered looks okay on the label and I get errors when
I
go to any other record.

Please help asap - of course I need this by Monday
Thanks,
Barb

"Allen Browne" wrote:

See:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

And:
Printing a Quantity of a Label
at:
http://members.iinet.net.au/~allenbrowne/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"babs" wrote in message
...
reposted since I haven't gotten an answer
ONE MORE thing- yeah sure.

I tried the max for the RecID to only print out the last record. It
prints
the last record entered but not really what I want. On the form I
would
acutally like if they press the PRINT LABEL button for it to print 3
copies
of the label-really 1sheet for that SPECIFIC record that is currently
visible????? not always the last record entered.

Please help asap -needed this done yesterday of course????
Thanks,
barb

Yes, the criteria "Forms!NameOfYourForm!NameOfPrimaryKeyTextbox" makes the
query for the report return the current record. Try it and see!!!

1. Instead of only 1, 2 and 3 in TblNumbers, add all the numbers up to what
you think will be the max number of labels ever wanted.
2. Create a popup form named PFrmNumOfLabels and put a combobox on the
form. Base the combobox on TblNumbers and name the combobox NumOfLabels. Set
the bound column property to 1, column count to 1 and column width to .5.
3. Put the following code in the OnOpen event of the popup form:
Me!NumOfLabels = 3
4. Add a button to the popup form and put the following code in the OnClick
event of the button:
Me.Visible = False
5. Put the following expression In the query for the label report:
=Forms!PFrmNumOfLabels!NumOfLabels
6. Put the following code in the OnOpen event of the report:
DoCmd.OpenForm "PFrmNumOfLabels",,,,,acDialog
DoCmd.Close acForm, "PFrmNumOfLabels"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"babs" wrote in message
news
will this make sure that only the current record - on that they have
entered
OR NAVIGATED TO WILL BE THE RECORD THAT THE LABEL REPORT GETS PRINTED FOR.
I
also would like them to be able to put in there own quantity of labels
with
the default of 3. Need this done by Monday morning. Thanks for helping.

Barb

"PC Datasheet" wrote:

Make sure your form contains a field for the primary key. Set its
visible
property to False. Create a table named TblNumbers with one field named
Number. Enter 1, 2 and 3 into the table. Base your label report on a
query.
Be sure to include the primary key (same primary key as your form). Add
TblNumbers to your query. There will be no join line! Put the following
expression in the criteria of the primary key:
Forms!NameOfYourForm!NameOfPrimaryKeyTextbox

When you press the print command button, you will get three labels for
the
current record on your form.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"babs" wrote in message
...
I tried this and it will only print the newest record entered. I
would
like
if the user navigates through the form that whatever record is in
focus
and
they press the print command button that label should be printed.
Right
now
only the last record entered looks okay on the label and I get errors
when
I
go to any other record.

Please help asap - of course I need this by Monday
Thanks,
Barb

"Allen Browne" wrote:

See:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

And:
Printing a Quantity of a Label
at:
http://members.iinet.net.au/~allenbrowne/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"babs" wrote in message
...
reposted since I haven't gotten an answer
ONE MORE thing- yeah sure.

I tried the max for the RecID to only print out the last record.
It
prints
the last record entered but not really what I want. On the form I
would
acutally like if they press the PRINT LABEL button for it to print
3
copies
of the label-really 1sheet for that SPECIFIC record that is
currently
visible????? not always the last record entered.

Please help asap -needed this done yesterday of course????
Thanks,
barb

I am getting an error for the criteria for the query. My primary key is an
autonumber ,long integer. Don't know the correct syntax for the
forms!nameofyourform!.....

thanks,
Barb

"PC Datasheet" wrote:

Yes, the criteria "Forms!NameOfYourForm!NameOfPrimaryKeyTextbox" makes the
query for the report return the current record. Try it and see!!!

1. Instead of only 1, 2 and 3 in TblNumbers, add all the numbers up to what
you think will be the max number of labels ever wanted.
2. Create a popup form named PFrmNumOfLabels and put a combobox on the
form. Base the combobox on TblNumbers and name the combobox NumOfLabels. Set
the bound column property to 1, column count to 1 and column width to .5.
3. Put the following code in the OnOpen event of the popup form:
Me!NumOfLabels = 3
4. Add a button to the popup form and put the following code in the OnClick
event of the button:
Me.Visible = False
5. Put the following expression In the query for the label report:
=Forms!PFrmNumOfLabels!NumOfLabels
6. Put the following code in the OnOpen event of the report:
DoCmd.OpenForm "PFrmNumOfLabels",,,,,acDialog
DoCmd.Close acForm, "PFrmNumOfLabels"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"babs" wrote in message
news
will this make sure that only the current record - on that they have
entered
OR NAVIGATED TO WILL BE THE RECORD THAT THE LABEL REPORT GETS PRINTED FOR.
I
also would like them to be able to put in there own quantity of labels
with
the default of 3. Need this done by Monday morning. Thanks for helping.

Barb

"PC Datasheet" wrote:

Make sure your form contains a field for the primary key. Set its
visible
property to False. Create a table named TblNumbers with one field named
Number. Enter 1, 2 and 3 into the table. Base your label report on a
query.
Be sure to include the primary key (same primary key as your form). Add
TblNumbers to your query. There will be no join line! Put the following
expression in the criteria of the primary key:
Forms!NameOfYourForm!NameOfPrimaryKeyTextbox

When you press the print command button, you will get three labels for
the
current record on your form.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"babs" wrote in message
...
I tried this and it will only print the newest record entered. I
would
like
if the user navigates through the form that whatever record is in
focus
and
they press the print command button that label should be printed.
Right
now
only the last record entered looks okay on the label and I get errors
when
I
go to any other record.

Please help asap - of course I need this by Monday
Thanks,
Barb

"Allen Browne" wrote:

See:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

And:
Printing a Quantity of a Label
at:
http://members.iinet.net.au/~allenbrowne/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"babs" wrote in message
...
reposted since I haven't gotten an answer
ONE MORE thing- yeah sure.

I tried the max for the RecID to only print out the last record.
It
prints
the last record entered but not really what I want. On the form I
would
acutally like if they press the PRINT LABEL button for it to print
3
copies
of the label-really 1sheet for that SPECIFIC record that is
currently
visible????? not always the last record entered.

Please help asap -needed this done yesterday of course????
Thanks,
barb

Assuming the name of your form is "FrmCustomers" and the CustomerID textbox
on your form is named "CustomerID", the syntax is:
Forms!FrmCustomers!CustomerID

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"babs" wrote in message
...
I am getting an error for the criteria for the query. My primary key is
an
autonumber ,long integer. Don't know the correct syntax for the
forms!nameofyourform!.....

thanks,
Barb

"PC Datasheet" wrote:

Yes, the criteria "Forms!NameOfYourForm!NameOfPrimaryKeyTextbox" makes
the
query for the report return the current record. Try it and see!!!

1. Instead of only 1, 2 and 3 in TblNumbers, add all the numbers up to
what
you think will be the max number of labels ever wanted.
2. Create a popup form named PFrmNumOfLabels and put a combobox on the
form. Base the combobox on TblNumbers and name the combobox NumOfLabels.
Set
the bound column property to 1, column count to 1 and column width to
..5.
3. Put the following code in the OnOpen event of the popup form:
Me!NumOfLabels = 3
4. Add a button to the popup form and put the following code in the
OnClick
event of the button:
Me.Visible = False
5. Put the following expression In the query for the label report:
=Forms!PFrmNumOfLabels!NumOfLabels
6. Put the following code in the OnOpen event of the report:
DoCmd.OpenForm "PFrmNumOfLabels",,,,,acDialog
DoCmd.Close acForm, "PFrmNumOfLabels"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"babs" wrote in message
news
will this make sure that only the current record - on that they have
entered
OR NAVIGATED TO WILL BE THE RECORD THAT THE LABEL REPORT GETS PRINTED
FOR.
I
also would like them to be able to put in there own quantity of labels
with
the default of 3. Need this done by Monday morning. Thanks for
helping.

Barb

"PC Datasheet" wrote:

Make sure your form contains a field for the primary key. Set its
visible
property to False. Create a table named TblNumbers with one field
named
Number. Enter 1, 2 and 3 into the table. Base your label report on a
query.
Be sure to include the primary key (same primary key as your form).
Add
TblNumbers to your query. There will be no join line! Put the
following
expression in the criteria of the primary key:
Forms!NameOfYourForm!NameOfPrimaryKeyTextbox

When you press the print command button, you will get three labels
for
the
current record on your form.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"babs" wrote in message
...
I tried this and it will only print the newest record entered. I
would
like
if the user navigates through the form that whatever record is in
focus
and
they press the print command button that label should be printed.
Right
now
only the last record entered looks okay on the label and I get
errors
when
I
go to any other record.

Please help asap - of course I need this by Monday
Thanks,
Barb

"Allen Browne" wrote:

See:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

And:
Printing a Quantity of a Label
at:
http://members.iinet.net.au/~allenbrowne/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"babs" wrote in message
...
reposted since I haven't gotten an answer
ONE MORE thing- yeah sure.

I tried the max for the RecID to only print out the last
record.
It
prints
the last record entered but not really what I want. On the
form I
would
acutally like if they press the PRINT LABEL button for it to
print
3
copies
of the label-really 1sheet for that SPECIFIC record that is
currently
visible????? not always the last record entered.

Please help asap -needed this done yesterday of course????
Thanks,
barb