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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
(e-mail address removed)
www.pcdatasheet.com
 
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
 
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
(e-mail address removed)
www.pcdatasheet.com
 
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
 
Assuming the name of your form is "FrmCustomers" and the CustomerID textbox
on your form is named "CustomerID", the syntax is:
Forms!FrmCustomers!CustomerID
 
Back
Top