![]() |
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() "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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|