A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing Labels from a form?



 
 
Thread Tools Display Modes
  #1  
Old November 17th, 2009, 01:47 PM posted to microsoft.public.access.forms
MFulton via AccessMonster.com
external usenet poster
 
Posts: 8
Default 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  
Old November 17th, 2009, 03:09 PM posted to microsoft.public.access.forms
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default 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  
Old November 17th, 2009, 04:48 PM posted to microsoft.public.access.forms
Mr. B[_4_]
external usenet poster
 
Posts: 171
Default 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  
Old November 17th, 2009, 05:17 PM posted to microsoft.public.access.forms
Thomas Kroljic
external usenet poster
 
Posts: 21
Default 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
print
custom labels when needed. Thanks in advance for your responses, they
are
appreciated

--
Message posted via http://www.accessmonster.com

.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.