Jumat, 11 Mei 2012

Re: [MS_AccessPros] Disable F11

 

Hi Bob
 
Thanks for joining in.
 
My db is not split. I have not weighed up the pros and cons of splitting and so far it doesn't seem to have been an issue.
 
I guess your advice would be to split - which will no doubt have me asking many more questions!!
 
But am I able to do what i want to do at the moment without splitting?
 
What is the answer to my question about whether the option settings apply to a database session or an access session?
 
cheers
 
Phil
 

________________________________
From: Robert Peterson <bob@alternatefinishing.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, 11 May 2012, 14:20
Subject: RE: [MS_AccessPros] Disable F11

 
Hi,
These last comments suggest to me that your database is not split.
Do you have a "back end data" file and a "front end forms and code" file?
If not you have some work to do.
A copy of the "front end" file is on each computer with the tables linked to the back end file stored on a server or shared folder somewhere on the network.

Bob Peterson

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

Hi John
 
OK I can live with setting it manually but I still have a problem if what I said before is happening.
 
ie I set the value. I then have to close the database session (ie get all the users off or wait until the last user comes off) and then start a new database session with the changed option setting. But this option setting will apply to all users who log on to that database session.
 
If this is the case it is no good for restricting the use of the F11 key
 
My only hope is that the option setting and resetting don't take effect for a complete database session but apply for the user who joins a currently open database by starting Access on his own PC and apply for that access session only.
 
Do you see what I mean and do you know which is the case?
 
cheers
 
Phil
 
 

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, 11 May 2012, 13:49
Subject: RE: [MS_AccessPros] Disable F11

 
Phil-

Ah, I didn't check that. It means that you have to close and reopen the database for the setting to take effect. But "Allow Special Keys" (and any other variation I tried) isn't a valid argument anyway. I couldn't find that option in any list for any version since 2003, so you probably can't set it in code.

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 2:14 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Disable F11

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]

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

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

Yahoo! Groups Links

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar