Override Access Function Keys Globally

[Lou Civitella]

I have a form that I would like to open when the user hits the F1 key no
matter where in Access the user is. Plus I do not want the Help system to
popup.

How do I go about doing this?

Thanks,
Lou

 

['69 Camaro]

Hi, Lou.

I have a form that I would like to open when the user hits the F1 key no
matter where in Access the user is.

You can do this with an AutoKeys macro. Create a new macro. In the "Macro
Name" column, type:

{F1}

In the "Action" column, select the "OpenForm" item from the combo box. In
the "Action Arguments" section in the lower pane, select the name of the
form you want to display when the <F1> key is hit. Save the new macro and
name it:

AutoKeys

Now, the user can hit the <F1> key from any database object such as a table,
form or report (modules in the VB Editor will ignore this command though,
and display the built-in Help), and your form will be displayed.

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.)

 

[Steve Schapel]

Lou,

Gunny's suggestions are correct. However, is there some other key you
can use instead of F1 which is traditionally used for Help?