Hi John
It would appear that the 'allowspecialkeys' option is only checked and applied when you open a database - and if you change the setting, it only applies from the time the you next open the database.
What I was wanting to do was to set its value to true or false depending on the currentuser() which I would do on OnLoad event of the startup form. This, I assume is after the options have been set for this usage session of the database.
I suppose therefore that, in a multiuser environment it will either be on or off for all users who log on during that session of the database being open and can only be changed when the last user in that session logs off.
I am confused now - because if this is the case then I won't be able to do what I want ...... ah unless it doesn't mean the opening of the database if it is already open, it means the starting of the access program by another user.
If you can clarify this for me I would very much appreciate it
cheers
Phil
________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, 11 May 2012, 11:47
Subject: 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]
[Non-text portions of this message have been removed]
Jumat, 11 Mei 2012
Re: [MS_AccessPros] Disable F11
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar