Disable Alter Key and F1 Key Globally of the database

[Irshad Alam]

I want to disable Alter key and F1 key globally (in
complete Database), what code to write, where to insert
that code, so that when the database opens, automatically
the Alter Key and F1 key will be disabled.

Please advise.

Pls. note that I received a reply earlier, which was not
suitable for me, as it was to write a function seprately,
open each form and report and write/call the code
manually. Its a quiet a lengthy process, as I about more
than 60 forms and 25 reports to deal with. Therefore, I am
looking for an alternate solution.

 

['69 Camaro]

Hi, Irshad.

One uses an AutoKey macro to globally control keyboard input in an Access
database application. Open Microsoft Access and press the <F1> key to read
all about creating AutoKeys in Help.

I assume that you mean the <ALT> key (abbreviation for "alternate") when you
refer to the "Alter key." If you plan to disable both the <F1> and <ALT>
keys in your application, then you may want to rethink your application's
design. A large percentage of Access users use these keys for opening the
Help screen or for hotkeys (aka "access keys"). Disabling either of these
keys in your database application is likely to frustrate and annoy your
users.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Irshad Alam]

Attn.: Friend Gunny

I have thought and found that it is needed for me to
disable both the keys mentioned below. could you suggest
me how to do.

Do you think, I will get a solution on the web page you
mentioned below.

regards

-----Original Message-----
Hi, Irshad.

One uses an AutoKey macro to globally control keyboard input in an Access
database application. Open Microsoft Access and press

 

['69 Camaro]

Hi, Irshad.

Do you think, I will get a solution on the web page you
mentioned below.

Access Help gives you the information you need for assigning the <F1> key to
an AutoKey. However, the <ALT> key isn't a valid key for AutoKeys (sorry,
my mistake -- <SHIFT> and <CTRL> are valid, but not <ALT>). If you explain
what it is that you are trying to keep your users from doing, perhaps we
could suggest an alternative to disabling the use of the <ALT> key.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)