dbTalk Databases Forums  

"use access special keys" checkbox has no affect

comp.databases.ms-access comp.databases.ms-access


Discuss "use access special keys" checkbox has no affect in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roger
 
Posts: n/a

Default "use access special keys" checkbox has no affect - 09-28-2011 , 02:11 AM






in access2007, under options->current database, I unchecked this
option
save and close the MDB

I reopen the mdb, and F11 is not disabled, it still opens the
navigation pane

I reopen the mdb with shift-enter, and the option is still unchecked
so F11 should be disabled

I tried using vba
Set MyDB = CurrentDb
MyDB .Properties("AllowBypassKey") = False
MyDB .Properties("AllowSpecialKeys") = False

same issue


what am I missing ?

Reply With Quote
  #2  
Old   
ron paii
 
Posts: n/a

Default Re: "use access special keys" checkbox has no affect - 09-28-2011 , 07:03 AM






"Roger" <lesperancer (AT) natpro (DOT) com> wrote

Quote:
in access2007, under options->current database, I unchecked this
option
save and close the MDB

I reopen the mdb, and F11 is not disabled, it still opens the
navigation pane

I reopen the mdb with shift-enter, and the option is still unchecked
so F11 should be disabled

I tried using vba
Set MyDB = CurrentDb
MyDB .Properties("AllowBypassKey") = False
MyDB .Properties("AllowSpecialKeys") = False

same issue


what am I missing ?
The property does not exist by default, you need to add it. Highlight
"AllowBypassKey" in the VBA editor and hit F1. Microsoft help explains it
and supplies a function to set properties and add them if missing.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.