ACCESS FEED: RE: [MS_AccessPros] Disable F11

Jumat, 11 Mei 2012

RE: [MS_AccessPros] Disable F11

Phil-

The link wrapped in the reply, so it's not complete. Try this:

http://tinyurl.com/cxuju38

As for setting the option "on the fly," take a look at the SetOption command. It's pretty simple:

Application.SetOption "<option name>", Value

Where Value is usually True or False (-1 or 0).

You can find a list of the option names here:

http://msdn.microsoft.com/en-us/library/aa189769(v=office.10).aspx

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

------------------------------------

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Phil Knowles
Sent: Friday, May 11, 2012 11:57 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Disable F11

Hi John

Thank you for that - I think the clearing of Use Special Keys may be OK but it would be better if I could do this programatically based on the user who logs on rather than manually - is there any way to do this?

I understand what you mean by setting the allowbypasskey to false but the link you gave me doesn't seem to work?

thanks again for all your help

Phil

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, 10 May 2012, 10:37
Subject: RE: [MS_AccessPros] Disable F11

Phil-

In Options / Current Database, clear the Use Special Keys option. Also set
AllowByPassKey to False to keep them from holding down the Shift key when
opening. See:

http://office.microsoft.com/en-us/access-help/allowbypasskey-property-HA001232717.aspx

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

----------------------

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of pdk444444
Sent: Thursday, May 10, 2012 11:19 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Disable F11

Hi

I would like to disable the F11 key for some of my users when they log on.

I have already disabled the ribbon (thanks to a previous post!) by adding code
to the startup form for these users.

What is the best way to do this?

Thanks in advance

Phil

[Non-text portions of this message have been removed]