Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 8th, 2004, 03:42 PM
Registered User
 
Join Date: Jun 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes please, If I could at least disable the File-Print menu item, that would be great. Menu bar also, I could make a standard toolbar with Close Report only on it... Thanks
 
Old December 8th, 2004, 03:51 PM
Registered User
 
Join Date: Jun 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

For the menu, I have found:

Reports!rpt1.MenuBar = "Nothing"

It will cancel the current menu and put instead mine which included nothing...
This way, he can only make a print screen, or add the tollbar, but we think that user are not that understandable of computer to do it, and if they did, then its of no big consequence... Let me know what you find, it might be better...

Thanks a lot...
 
Old December 8th, 2004, 04:03 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

That looks far better and cleaner than anything I have come up with yet, and if it works then it has another advantage over mine. I have been looking at the Startup Properties under VBA Help, but as yet they haven't yielded anything but errors!

Look like we are done though - Thanks

Mike
EchoVue.com
 
Old December 8th, 2004, 04:06 PM
Registered User
 
Join Date: Jun 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks a lot for your help, I appreciate it!
 
Old March 25th, 2006, 01:35 AM
Registered User
 
Join Date: Mar 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by sbergeron
 Thanks a lot for your help, I appreciate it!
Try this.. IT WORKS! I had your same issue..

I found out how to do this... it's so simple, but I
haven't used it in a long time so I forgot. In case anyone
else wants to know ... create a macro called AutoKeys,
inside the macro put ^P inside the macro name column (You may have to go to the view menu to make this column visible)
(leave all other columns blank) [- Here I departed and selected a "beep" for the macro command - Give that ol' user a hint that he's not allowed to print using ctrl-p!!]. Now the user can't use
CTRL+P to print a report






Similar Threads
Thread Thread Starter Forum Replies Last Post
how to print sub report NagarajuK Crystal Reports 0 December 3rd, 2007 10:05 AM
Print Access report from SQL stored procedure feets Access VBA 0 February 12th, 2007 06:58 AM
Access report print each page to separate PDF file conh2so4aq Access VBA 5 July 3rd, 2006 08:00 PM
How to print access report through printdialog? leung_kenneth VB.NET 0 March 2nd, 2005 01:18 AM
print report lazio Crystal Reports 0 November 1st, 2004 08:38 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.