Disable copy, cut, and paste

  • Thread starter Thread starter A C
  • Start date Start date
A

A C

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
 
We want to disable copy/cut on certain datasheets (sensitive data).
Click to expand...

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]
 
John Vinson said:
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]
Click to expand...

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
 
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...
Click to expand...

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]
 
John Vinson said:
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]
Click to expand...

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
 
Back
Top