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
|
|||
|
|||
Disable copy, cut, and paste
Hi
We want to disable copy/cut on certain datasheets (sensitive data). Is there a way to do this in Access? I have a link to a way to do it in Excel: http://www.xcelfiles.com/VBA_Quick13.html Is there an equiv in Access, or a way to get the above to apply to Access? FWIW, the MS Access app is going to be totally "baren", so all file menus and buttons etc will be hidden as well. Thanks A |
#2
|
|||
|
|||
Disable copy, cut, and paste
On Wed, 9 Nov 2005 11:16:30 +1300, "A C" wrote:
We want to disable copy/cut on certain datasheets (sensitive data). Even if there is, there's NO way to prevent the user from capturing a screenshot - with a hand-held digital camera, if nothing else. John W. Vinson[MVP] |
#3
|
|||
|
|||
Disable copy, cut, and paste
"John Vinson" wrote in message ... On Wed, 9 Nov 2005 11:16:30 +1300, "A C" wrote: We want to disable copy/cut on certain datasheets (sensitive data). Even if there is, there's NO way to prevent the user from capturing a screenshot - with a hand-held digital camera, if nothing else. John W. Vinson[MVP] Yes that is true, but as you say it is unavoidable so we are just trying to do the best we can to make it harder... Regards A |
#4
|
|||
|
|||
Disable copy, cut, and paste
On Wed, 9 Nov 2005 14:17:17 +1300, "A C" wrote:
Yes that is true, but as you say it is unavoidable so we are just trying to do the best we can to make it harder... You could set the Form's KeyPreview property to true, and trap the Ctrl-C and Ctrl-X characters; and of course remove the Cut and Copy options from the menu by using your own custom menu rather than the default. John W. Vinson[MVP] |
#5
|
|||
|
|||
Disable copy, cut, and paste
"John Vinson" wrote in message ... On Wed, 9 Nov 2005 14:17:17 +1300, "A C" wrote: Yes that is true, but as you say it is unavoidable so we are just trying to do the best we can to make it harder... You could set the Form's KeyPreview property to true, and trap the Ctrl-C and Ctrl-X characters; and of course remove the Cut and Copy options from the menu by using your own custom menu rather than the default. John W. Vinson[MVP] Thanks John, those are good suggestions. Anyone else have any more ideas? Its a shame Access does not have similar functionality to Excel as shown in http://www.xcelfiles.com/VBA_Quick13.html. If anyone knows of how to do similar to this link then please post. Regards Andrew |
#6
|
|||
|
|||
Disable copy, cut, and paste
Do not forget about Ctrl+Ins and Shift+Del also
-- Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com "John Vinson" wrote in message ... On Wed, 9 Nov 2005 14:17:17 +1300, "A C" wrote: Yes that is true, but as you say it is unavoidable so we are just trying to do the best we can to make it harder... You could set the Form's KeyPreview property to true, and trap the Ctrl-C and Ctrl-X characters; and of course remove the Cut and Copy options from the menu by using your own custom menu rather than the default. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|