Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2005

Tip: Looking for answers? Try searching our database.

disabling keyboard shortcuts in access form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandy - 01 Dec 2005 09:22 GMT
I want to disable few control keyboard functions like ^F or ^S or Alt f4 etc  
in form view when user uses form. pleaee advice. Form will open as pop up.

Also if i want to allow edit in form but disable replace function in find
and replace command.  Please advice
Allen Browne - 01 Dec 2005 09:41 GMT
1. Create a macro named "AutoKeys". (The name is important).

2. Show the Macro Names column View menu.)

3. In the macro column type a caret (Shift+6) followed by an S.
In the Action column, choose an innocuous action, such as Beep.

4. On the next line of the macro, specify the next key combination.
Your macro will now look like this:
   ^S            Beep
   ^F            Beep

Now Ctrl+S will be handled by the macro instead of the default.

You can reassign Ctrl+F4 with the name:
   ^{F4}
In general, you use the percent charater (%) to represent the Alt key
combinations, but %{F4} is not permitted. To disable Alt+F4, you would need
to use the KeyDown event of each form.

The question arises as to why you are doing this, as it is likely to
frustrate good data entry operators, who invariably know the standard
shortcut keys and find it faster than the mouse. Is is just because you
don't understand how to design an event-driven program? For example, if you
want to run some checks before the record is saved, the BeforeUpdate event
of the *form* will let you do that.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I want to disable few control keyboard functions like ^F or ^S or Alt f4
>etc
> in form view when user uses form. pleaee advice. Form will open as pop up.
>
> Also if i want to allow edit in form but disable replace function in find
> and replace command.  Please advice
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.