[AccessD] Disabling Ctrl-A

Thanks Jim,

Another good thought - I could just have the search boxes and show records 
as they match the criteria.  However the way we have solved it this time is 
to remove the record selectors.  Now with no record selectors, Ctrl-A being 
cancelled by Autokeys, and Select all records not appearing in the menu I 
think we have covered all bases.

David

At 6/04/2005, you wrote:
> >>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