bylj
asked on
How to disable printing of a report
Have a report for viewing only, but the users keep on printing it by using Ctrl+P. Is there anyway I can make it a pure view-only report? How?
thanks
thanks
Even if you could disable CTRL+P there would be nothng stopping the user doing a print screen.
OK what about trying when Key press event to redirect the key press to a preview mode not printing mode !!! I dont know I have to test it but this a hint for you guys to try also, correct me if i'm wrong,, cheers
Sinan
Sinan
or you could maybe use SendKey to pop up a message box stating that the function is not allowed
sorry i mean AutoKeys.
create a new macro named AutoKeys
make sure View Macro Name is set on
type ^p in Macro Name
set Action = Message Box (or Whatever)
whenever the user hits ctrl+p the message box will load.
create a new macro named AutoKeys
make sure View Macro Name is set on
type ^p in Macro Name
set Action = Message Box (or Whatever)
whenever the user hits ctrl+p the message box will load.
ASKER
Reports dont have a Key_Press_Event.
you dont need a key press event for my solution
Just a side observation ..
If your users WANT to print your report so badly, why don't you give them that option?
If your users WANT to print your report so badly, why don't you give them that option?
ASKER
Datrias:
Your solution would disable Ctrl-P for the whole app. I have certain reports that are printable but couple are NOT to be printed
Your solution would disable Ctrl-P for the whole app. I have certain reports that are printable but couple are NOT to be printed
there is an event-
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
End Sub
you need to add this:
Cancel = True
THis should do the trick.
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
End Sub
you need to add this:
Cancel = True
THis should do the trick.
ASKER
tried, it would still print
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
TextReport,
Welcome to Expert's Exchange!
I've rejected your proposed answer for a couple of reasons.
First, by proposing an answer, you move the question from the Open Questions queue to the Locked Questions queue. That makes it much less likely that the Asker will get responses to his question.
Second, you should only propose an answer when you are 100 per cent certain that your response is the ONLY one true answer that will work AND that your response does not duplicate or paraphrase someone else's response.
Again, welcome aboard.
Netminder
CS Moderator
Welcome to Expert's Exchange!
I've rejected your proposed answer for a couple of reasons.
First, by proposing an answer, you move the question from the Open Questions queue to the Locked Questions queue. That makes it much less likely that the Asker will get responses to his question.
Second, you should only propose an answer when you are 100 per cent certain that your response is the ONLY one true answer that will work AND that your response does not duplicate or paraphrase someone else's response.
Again, welcome aboard.
Netminder
CS Moderator
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- PAQ'd and pts removed
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
Nic;o)
Nico,
Isn't "You can't do that" a valid answer?
Best regards,
ep
Isn't "You can't do that" a valid answer?
Best regards,
ep
Well, when you "dive" into the API's you should be able to intercept the keystrokes to a window. Not easy, but it should be possible.
Always after making a backup ofcourse, but you should know that ;-)
Nic;o)
Always after making a backup ofcourse, but you should know that ;-)
Nic;o)
I still maintain that the answer proposed by me in my first few days on EE is the correct answer, the answer ws not rejected by the person asking the question, this does resolve the question that was originally asked.
EP is incorrect in the statement that you cannnot stop control-p, this is the standard keystroke in windows for teh print dialogue but it is at the control of the application.
Cheers, Andrew
EP is incorrect in the statement that you cannnot stop control-p, this is the standard keystroke in windows for teh print dialogue but it is at the control of the application.
Cheers, Andrew
I guess it will work, but as bylj wants this to be used selectively, it's not completely suiting his needs...
See:
Comment from bylj
05/23/2002 08:14AM PST
Datrias:
Your solution would disable Ctrl-P for the whole app. I have certain reports that are printable but couple are NOT to be printed
Nic;o)
See:
Comment from bylj
05/23/2002 08:14AM PST
Datrias:
Your solution would disable Ctrl-P for the whole app. I have certain reports that are printable but couple are NOT to be printed
Nic;o)
Then you include the ones you don't want to print in the case statement along with Case "AJTest".
Cheers, Andrew
Cheers, Andrew
textReport's answer looks good to me
textReport's answer looks good to me
OK, I'll change my recommendation into
- answered by: TextReport
Perhaps too much distracted by the answer rejection...
Nic;o)
- answered by: TextReport
Perhaps too much distracted by the answer rejection...
Nic;o)
nico,
It happens; the rejection was caused by the request of an Expert (as I recall) who objected to the question being locked. It in no way was intended to reflect on the validity of the comment.
As soon as they give us our tools back, I'll take care of this and the other questions which have had closing recommendations left in them.
Netminder
CS Moderator
It happens; the rejection was caused by the request of an Expert (as I recall) who objected to the question being locked. It in no way was intended to reflect on the validity of the comment.
As soon as they give us our tools back, I'll take care of this and the other questions which have had closing recommendations left in them.
Netminder
CS Moderator
Per recommendation, force-accepted.
Netminder
CS Moderator
Netminder
CS Moderator
You might be able to do a redirect so that the report prints to the screen, but it's beyond my capabilities.
Good luck,
ep