Disable F11 Key

[Guest]

to I've hidden the Access database window and on a form, have a button unhide
it. However, sometimes a user will use the F11 key at an inappropriate place
to make the window appear.

Even though I'm fairly new to VB Application, I probaly should know this or
at least be able to find the anwer in my notes, but I haven't been able to.
So here's my question: how do you disable the F11 key?

 

[Rick Brandt]

to I've hidden the Access database window and on a form, have a
button unhide it. However, sometimes a user will use the F11 key at
an inappropriate place to make the window appear.

Even though I'm fairly new to VB Application, I probaly should know
this or at least be able to find the anwer in my notes, but I haven't
been able to. So here's my question: how do you disable the F11 key?

Tools
Startup
[Advanced >>]
"Use Access Special Keys"

 

[Guest]

Create a macro named AutoKeys.

In the Macro Name column, enter:
{F11}

 

[Guest]

Hi Ofer,

Where does one find the Macro Name column?
As far as I can see, there is only Action and Comment.
Thanks

 

[Duane Hookom]

IIRC select View from the top menu and look for it.

 

[Guest]

Hi Duane,
Thanks for your answer. But what does IIRC stand for? I can't figure it out.

 

[Douglas J. Steele]

If I Recall Correctly

 

[tina]

Duane did remember correctly; in the macro design view, you can show those
two columns by selecting them from the View menu. that will affect the macro
that you have open.

to make the Name and Condition columns show "by default" in all *new*
macros: in the database window, click Tools | Options | View tab. in the
"Show in Macro Design" section, checkmark the boxes next to "Names column"
and "Conditions column". then click OK. note that these settings will apply
to all NEW macros you create in ANY database. for existing macros in any
database, you have to "show" the columns manually from the View menu in the
macro design view, as described previously.

hth

 

[Guest]

So I have created the AutoKeys macro.
Does this auto run when the Access application is opened?
Or can I run this macro based on the user who is loggin into the application?
Thanks in advance

Richard
DB Design

 

[Douglas J. Steele]

As long as the macro exists, it's operational. If you only want it for
specific users, name the macro something other than AutoKeys, and rename it
whenever the specific users are using the application.

 

[Guest]

Thanks for your feedback

So when does the AutoKeys execute?

I have a user log in form ..
- the user selects their user id and enters thier passwork
So the VBA code in the AfterUpdate event would be...
If me.cboUserID = "RLP" then ' A user I want to have access to the F11 key
(rename macro NoAutoKeys)
else
(rename macro to AutoKeys)
End If

Thanks in advance

 

[Douglas J. Steele]

It's not really a case of "executing". It's always running, catching
whatever keystrokes have been defined to it.

To rename, you'd use

DoCmd.Rename "AutoKeys", acMacro, "NoAutoKeys"

to rename NoAutoKeys to AutoKeys, or

DoCmd.Rename "NoAutoKeys", acMacro, "AutoKeys"

to rename AutoKeys to NoAutoKeys.

Note that if the macro you're trying to rename doesn't currently exist,
you'll get an error 3011.

Another option, of course, is to give RLP a different hot key to use (and
hope that the others users don't find out what it is)

 

[Marco]

Great. Works perfectly

It's not really a case of "executing". It's always running, catching
whatever keystrokes have been defined to it.

To rename, you'd use

DoCmd.Rename "AutoKeys", acMacro, "NoAutoKeys"

to rename NoAutoKeys to AutoKeys, or

DoCmd.Rename "NoAutoKeys", acMacro, "AutoKeys"

to rename AutoKeys to NoAutoKeys.

Note that if the macro you're trying to rename doesn't currently exist,
you'll get an error 3011.

Another option, of course, is to give RLP a different hot key to use (and
hope that the others users don't find out what it is)