[AccessD] Disabling Ctrl-A

>>Does anyone have any thoughts on the other problem - manually selecting all 
records with
the mouse<<

How about filtering the form so only a subset of data is available at a time?

HTH,

Jim DeMarco

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson
Sent: Thursday, March 31, 2005 7:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Disabling Ctrl-A


Ah, I knew there would be a simple solution - Thanks Lonnie.

Does anyone have any thoughts on the other problem - manually selecting all records with
the mouse, then copying them to the clipboard.  I don't want to disable 
Ctrl-C because it is useful elsewhere in the programme.  Is there a way to check if records are selected (any number of records - not just all of them)?

David

At 1/04/2005, Lonnie wrote:
>You could use the autokeys macro to override the control A and send a 
>msgbox saying "Can't do that"
>
>David Emerson <newsgrps at dalyn.co.nz> wrote:AXP
>
>One of my users has discovered that by selecting Ctrl-A this will select
>all records. Then he can copy, open up Excel and paste all the records
>into a spreadsheet. However, because of the sensitive nature of the data,
>Management do not want the full database to be available this way.
>
>How can I disable Ctrl-A so that all records cannot be selected. I have
>already removed from my custom menu the option to Select all records but
>Ctrl-A still works.
>
>Of course there is still the problem of manually selecting all records with
>the mouse - any thoughts on this problem as well?
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>25 Cunliffe St, Churton Park
>Wellington, New Zealand
>Ph/Fax (04) 478-7456
>Mobile 027-280-9348

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


 



***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************