If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Print Access 97 Mailing Labels in the "middle" of a sheet of label | TDMueller | Setting Up & Running Reports | 7 | December 22nd, 2004 04:03 AM |
Cannot print a sheet of labels only top left label | Abe Poole | Publisher | 3 | December 15th, 2004 10:40 PM |
Creating a report from a form | Kristin | Setting Up & Running Reports | 7 | June 28th, 2004 09:21 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |
Query Form: Print Report | Dennis | Running & Setting Up Queries | 1 | June 6th, 2004 01:08 PM |