AllowSpecialKeys

AllowSpecialKeys

Postby JohnH » 13 Nov 2010, 03:17

I have been asked to disable F11 for one group of users, but it seems to me (after some time of experimentation) that any changes to AllowSpecialkeys don't take effect until the next time the database is opened. So my plan of using VBA will never work. Does that seem right? I would need to create a separate Front End for these users.
Regards

John
Post=32887
JohnH
3StarLounger
 
Posts: 277
Joined: 09 Mar 2010, 23:16
Location: Mt Macedon Australia

Re: AllowSpecialKeys

Postby JohnH » 13 Nov 2010, 04:26

On further reflection, my previous post does not reflect very clear thinking.

Giving these users a different front end, assumes they always use the same computer(s). In that case, changing AllowSpecialkeys would work, except for the first time. So I now have this code:

Code: Select all
If ((fnIsAdmin() = True) Or (fnIsGroupMember("RealUsers") = True)) Then
       If CurrentDb.Properties("AllowSpecialKeys") = False Then
           CurrentDb.Properties("AllowSpecialKeys") = True
           MsgBox "You need to reopen the database.", vbInformation
           DoCmd.Quit
        End If
        Else
        If CurrentDb.Properties("AllowSpecialKeys") = True Then
           CurrentDb.Properties("AllowSpecialKeys") = False
           MsgBox "You need to reopen the database.", vbInformation
           DoCmd.Quit
        End If

     End If


This creates a further problem. The very people who can't use F11, don't have permission to Administer the database, so I get this error.
MysysDB.gif


If I give them permission the error goes away. But I don't want to give them that permission.
You do not have the required permissions to view the files attached to this post.
Regards

John
Post=32889
JohnH
3StarLounger
 
Posts: 277
Joined: 09 Mar 2010, 23:16
Location: Mt Macedon Australia

Re: AllowSpecialKeys

Postby HansV » 13 Nov 2010, 11:04

I guess you'll have to instruct the power users to turn off Allow Special Keys before closing the database, if they turned it on.
Regards,
Hans
Post=32894
User avatar
HansV
Clever Clogs
 
Posts: 31567
Joined: 16 Jan 2010, 00:14
Location: Leiden, The Netherlands


Return to Access/SQL

Who is online

Users browsing this forum: CCBot [Bot] and 0 guests