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 problem



 
 
Thread Tools Display Modes
  #1  
Old January 26th, 2009, 08:38 PM posted to microsoft.public.access.forms
Tim
external usenet poster
 
Posts: 780
Default Printing problem

I have a form with student info on the form and a button "Requery" next to
that form. When I click on that button and input a new studentId at the
prompt, the form will be refreshed and show up that new student info. When I
print out that form, a second page will be printed out also with that button.
I want to print out the form ONLY without the second page (waste paper and
waste time). I moved the button around, i.e., on the top of the form, so I
can print out the form only (on one page), but it also include the button at
the top. I don't want the button on the form.
Can you please help me? Thanks in advance.
  #2  
Old January 26th, 2009, 10:47 PM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Printing problem

Tim,

Might the problem be that you are using forms (not meant for printing) as
opposed to a report which could easlily be linked to the record you want to
print? Is there a reason you choose to use the form instead of a report?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

"Tim" wrote in message
...
I have a form with student info on the form and a button "Requery" next to
that form. When I click on that button and input a new studentId at the
prompt, the form will be refreshed and show up that new student info. When
I
print out that form, a second page will be printed out also with that
button.
I want to print out the form ONLY without the second page (waste paper
and
waste time). I moved the button around, i.e., on the top of the form, so I
can print out the form only (on one page), but it also include the button
at
the top. I don't want the button on the form.
Can you please help me? Thanks in advance.



  #3  
Old January 27th, 2009, 03:16 PM posted to microsoft.public.access.forms
Tim
external usenet poster
 
Posts: 780
Default Printing problem

Hi Gina, thanks for response. I scaned a real form and saved it as a bitmap.
The form is supposed to fill in by hand but now converted to a computer-based
form. The prompt asks for studID once entered will put that student info on
the form. I think I will have to create a new report similar to this form.
When clicking on the newly created "Print" button on this form, the report
will be printed out instead of the form. Do you think that's the way to do or
do you have a better idea? Thanks again. I appreciate your help.

"Gina Whipp" wrote:

Tim,

Might the problem be that you are using forms (not meant for printing) as
opposed to a report which could easlily be linked to the record you want to
print? Is there a reason you choose to use the form instead of a report?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

"Tim" wrote in message
...
I have a form with student info on the form and a button "Requery" next to
that form. When I click on that button and input a new studentId at the
prompt, the form will be refreshed and show up that new student info. When
I
print out that form, a second page will be printed out also with that
button.
I want to print out the form ONLY without the second page (waste paper
and
waste time). I moved the button around, i.e., on the top of the form, so I
can print out the form only (on one page), but it also include the button
at
the top. I don't want the button on the form.
Can you please help me? Thanks in advance.




  #4  
Old January 27th, 2009, 08:11 PM posted to microsoft.public.access.forms
דרור
external usenet poster
 
Posts: 11
Default Did you try to use the "Display When" property of the button?

Hi:

Did you try to use the "Display When" property of the button? Set it to
Screen only so that it will not be printed with the form.

Dror
  #5  
Old January 27th, 2009, 08:51 PM posted to microsoft.public.access.forms
Tim
external usenet poster
 
Posts: 780
Default Did you try to use the "Display When" property of the button?

Wow! It works like a charm!!! Thank you very much!!!! I appreciate it!!!

"דרור" wrote:

Hi:

Did you try to use the "Display When" property of the button? Set it to
Screen only so that it will not be printed with the form.

Dror

 




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 09:19 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.