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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How not to print buttons on a report?



 
 
Thread Tools Display Modes
  #1  
Old August 7th, 2009, 07:46 PM posted to microsoft.public.access.gettingstarted
StargateFanNotAtHome[_2_]
external usenet poster
 
Posts: 11
Default How not to print buttons on a report?

I've created my Access 2007 solution in a couple of hours. It works
great although I have a couple of questions that I'll ask in this ng.
I even was able to put buttons on the report to make my life easier,
though it's not something usually done, I'm sure. In Excel, you can
right-click and tell Excel not to print a button so your sheet can be
covered with button that have macros attached to them but they don't
print out. You get a regular spreadsheet printout.

Can this be done in Access, too?

I have a PRINT button and a CLOSE one and they both work very well,
it's just that they print out on the report, which is not nice.

How to fix that, pls?
  #2  
Old August 8th, 2009, 05:19 AM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default How not to print buttons on a report?

StargateFanNotAtHome,
Sounds like you're printing the image of a form, (ergo the printed
buttons)
rather than creating a real report.
If so, on the form, set the button's Display When property to Screen
Only.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


" wrote in message
...
I've created my Access 2007 solution in a couple of hours. It works
great although I have a couple of questions that I'll ask in this ng.
I even was able to put buttons on the report to make my life easier,
though it's not something usually done, I'm sure. In Excel, you can
right-click and tell Excel not to print a button so your sheet can be
covered with button that have macros attached to them but they don't
print out. You get a regular spreadsheet printout.

Can this be done in Access, too?

I have a PRINT button and a CLOSE one and they both work very well,
it's just that they print out on the report, which is not nice.

How to fix that, pls?



  #3  
Old August 8th, 2009, 06:02 AM posted to microsoft.public.access.gettingstarted
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default How not to print buttons on a report?

Al, that's what happens in A2003. I checked in A2007 and you can definitely
put buttons on a report - that's quite a change to what we are accustomed to
doing. I can't see any properties where you set the buttons to not print
though.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Al Campagna" wrote in message
...
StargateFanNotAtHome,
Sounds like you're printing the image of a form, (ergo the printed
buttons)
rather than creating a real report.
If so, on the form, set the button's Display When property to Screen
Only.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


" wrote in message
...
I've created my Access 2007 solution in a couple of hours. It works
great although I have a couple of questions that I'll ask in this ng.
I even was able to put buttons on the report to make my life easier,
though it's not something usually done, I'm sure. In Excel, you can
right-click and tell Excel not to print a button so your sheet can be
covered with button that have macros attached to them but they don't
print out. You get a regular spreadsheet printout.

Can this be done in Access, too?

I have a PRINT button and a CLOSE one and they both work very well,
it's just that they print out on the report, which is not nice.

How to fix that, pls?





  #4  
Old August 8th, 2009, 12:57 PM posted to microsoft.public.access.gettingstarted
hattie
external usenet poster
 
Posts: 1
Default How not to print buttons on a report?


"Jeanette Cunningham" wrote in message
...
Al, that's what happens in A2003. I checked in A2007 and you can
definitely put buttons on a report - that's quite a change to what we are
accustomed to doing. I can't see any properties where you set the buttons
to not print though.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Al Campagna" wrote in message
...
StargateFanNotAtHome,
Sounds like you're printing the image of a form, (ergo the printed
buttons)
rather than creating a real report.
If so, on the form, set the button's Display When property to Screen
Only.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."


" wrote in message
...
I've created my Access 2007 solution in a couple of hours. It works
great although I have a couple of questions that I'll ask in this ng.
I even was able to put buttons on the report to make my life easier,
though it's not something usually done, I'm sure. In Excel, you can
right-click and tell Excel not to print a button so your sheet can be
covered with button that have macros attached to them but they don't
print out. You get a regular spreadsheet printout.

Can this be done in Access, too?

I have a PRINT button and a CLOSE one and they both work very well,
it's just that they print out on the report, which is not nice.

How to fix that, pls?






  #5  
Old August 8th, 2009, 02:52 PM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default How not to print buttons on a report?

Hi Jeanette,
Good point... I was not aware of that.
Well, we'll just have to see what the OP really means.

Thanks
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."



"Jeanette Cunningham" wrote in message
...
Al, that's what happens in A2003. I checked in A2007 and you can
definitely put buttons on a report - that's quite a change to what we are
accustomed to doing. I can't see any properties where you set the buttons
to not print though.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Al Campagna" wrote in message
...
StargateFanNotAtHome,
Sounds like you're printing the image of a form, (ergo the printed
buttons)
rather than creating a real report.
If so, on the form, set the button's Display When property to Screen
Only.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."


" wrote in message
...
I've created my Access 2007 solution in a couple of hours. It works
great although I have a couple of questions that I'll ask in this ng.
I even was able to put buttons on the report to make my life easier,
though it's not something usually done, I'm sure. In Excel, you can
right-click and tell Excel not to print a button so your sheet can be
covered with button that have macros attached to them but they don't
print out. You get a regular spreadsheet printout.

Can this be done in Access, too?

I have a PRINT button and a CLOSE one and they both work very well,
it's just that they print out on the report, which is not nice.

How to fix that, pls?







  #6  
Old August 8th, 2009, 02:58 PM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default How not to print buttons on a report?

Stargate,
After reading Jeanette's reply... which is correct... my solution would
still
apply...
Those buttons on the report have a Display When property too.
(Just like buttons on a printed form)
Try setting Display When to Screen Only.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"StargateFanNotAtHome" wrote in
message
...
I've created my Access 2007 solution in a couple of hours. It works
great although I have a couple of questions that I'll ask in this ng.
I even was able to put buttons on the report to make my life easier,
though it's not something usually done, I'm sure. In Excel, you can
right-click and tell Excel not to print a button so your sheet can be
covered with button that have macros attached to them but they don't
print out. You get a regular spreadsheet printout.

Can this be done in Access, too?

I have a PRINT button and a CLOSE one and they both work very well,
it's just that they print out on the report, which is not nice.

How to fix that, pls?



 




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:13 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.