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
|
|||
|
|||
Printing Labels from a form?
Greetings,
Goal: I just want a form where the user can type in what needs to be printed on a label and click the print button to print it. For example: If the user needs to print a label that says: Monday, they type monday into a text box and click print and the label prints. Any ideas, I don't need the any of the information they are typing in saved, just need the user to be able to print custom labels when needed. Thanks in advance for your responses, they are appreciated -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Printing Labels from a form?
On Tue, 17 Nov 2009 12:47:08 GMT, "MFulton via AccessMonster.com"
u21881@uwe wrote: Say you have a form named myForm with a textbox named myTextbox. Create an unbound blank report, put a textbox on it, and set the controlsource to: =Forms!myForm!myTextbox -Tom. Microsoft Access MVP Greetings, Goal: I just want a form where the user can type in what needs to be printed on a label and click the print button to print it. For example: If the user needs to print a label that says: Monday, they type monday into a text box and click print and the label prints. Any ideas, I don't need the any of the information they are typing in saved, just need the user to be able to print custom labels when needed. Thanks in advance for your responses, they are appreciated |
#3
|
|||
|
|||
Printing Labels from a form?
To add to what Tom has said;
If you just wanted to print the info typed into the text box on a sheet of paper then what Tom suggested will do that just fine. However, if you are wanting to print to a sheet of labels, you will first have to define your report to fit you sheet of labels. Also need some method that will allow the user to specify then exact label on the sheet of labels where the current information is to be printed. Create your report and verify that it will print correctly on each and every label. As for allowing the user to specify the label where the info is to be printed, I use a special form that I created that presents the user with a replica of the sheet of labels. The user can then just click on the label where the printing is to occur and the report will take the information passed from the form to the report and print the data on the desired label. It will take some programming, but it can be done. ----- HTH Mr. B http://www.askdoctoraccess.com/ Doctor Access Downloads Page: http://www.askdoctoraccess.com/DownloadPage.htm "MFulton via AccessMonster.com" wrote: Greetings, Goal: I just want a form where the user can type in what needs to be printed on a label and click the print button to print it. For example: If the user needs to print a label that says: Monday, they type monday into a text box and click print and the label prints. Any ideas, I don't need the any of the information they are typing in saved, just need the user to be able to print custom labels when needed. Thanks in advance for your responses, they are appreciated -- Message posted via http://www.accessmonster.com . |
#4
|
|||
|
|||
Printing Labels from a form?
Following up on what Mr. B wrote, if you do a Google search for the logic
(vba) that would allow the user to select the appropriate label to print on, you'll find something you can immediately use. You might want to try this website: http://www.granite.ab.ca/accsmstr.htm they might have what you need. "Mr. B" wrote in message ... To add to what Tom has said; If you just wanted to print the info typed into the text box on a sheet of paper then what Tom suggested will do that just fine. However, if you are wanting to print to a sheet of labels, you will first have to define your report to fit you sheet of labels. Also need some method that will allow the user to specify then exact label on the sheet of labels where the current information is to be printed. Create your report and verify that it will print correctly on each and every label. As for allowing the user to specify the label where the info is to be printed, I use a special form that I created that presents the user with a replica of the sheet of labels. The user can then just click on the label where the printing is to occur and the report will take the information passed from the form to the report and print the data on the desired label. It will take some programming, but it can be done. ----- HTH Mr. B http://www.askdoctoraccess.com/ Doctor Access Downloads Page: http://www.askdoctoraccess.com/DownloadPage.htm "MFulton via AccessMonster.com" wrote: Greetings, Goal: I just want a form where the user can type in what needs to be printed on a label and click the print button to print it. For example: If the user needs to print a label that says: Monday, they type monday into a text box and click print and the label prints. Any ideas, I don't need the any of the information they are typing in saved, just need the user to be able to custom labels when needed. Thanks in advance for your responses, they are appreciated -- Message posted via http://www.accessmonster.com . |
Thread Tools | |
Display Modes | |
|
|