Allow Special Keys

[Jasemc2]

I have several databases that I have unchecked the "Allow Special Keys" and I
wanted to change one back so that it would allow the special keys and I have
checked the box again. However, even when I close out of the database and go
back in I cannot use the special keys. I have checked the options to make
sure it is still checked and it is, but it will not re-enable the
functionality.


How can I fix this?


Also is there a way to change this option thorugh VBA so that it can be
turned off and on depending on user security that I have set up?

 

[Scott McDaniel]

I have several databases that I have unchecked the "Allow Special Keys" and
I
wanted to change one back so that it would allow the special keys and I
have
checked the box again. However, even when I close out of the database and
go
back in I cannot use the special keys. I have checked the options to make
sure it is still checked and it is, but it will not re-enable the
functionality.

What functionality are you trying to re-enable?

You can't use VBA to re-enable this functionality in the current session of
Access; you'll have to re-enable, then close the current session and
re-open.

 

[Keith Wilby]

I have several databases that I have unchecked the "Allow Special Keys" and
I
wanted to change one back so that it would allow the special keys and I
have
checked the box again. However, even when I close out of the database and
go
back in I cannot use the special keys. I have checked the options to make
sure it is still checked and it is, but it will not re-enable the
functionality.


How can I fix this?

Hold down the shift key when you open the mdb file.

Also is there a way to change this option thorugh VBA so that it can be
turned off and on depending on user security that I have set up?

Do you mean disable/enable the bypass key? If so then Albert Kallal has a
free utility:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

HTH - Keith.
www.keithwilby.com

 

[Jasemc2 via AccessMonster.com]

I would like the F11 key to work as well as the right click pop up menus. I
know I can build popup menus but this only works in form view and if I am
doing maintenance on a database it is a hassel to use the menu bars instead
of the pop up menus. I would have thought that under the
tools|options|check the Use Access Special Keys would have restored the
functionality.

I have several databases that I have unchecked the "Allow Special Keys" and
I

[quoted text clipped - 5 lines]

sure it is still checked and it is, but it will not re-enable the
functionality.

What functionality are you trying to re-enable?

You can't use VBA to re-enable this functionality in the current session of
Access; you'll have to re-enable, then close the current session and
re-open.

How can I fix this?

Also is there a way to change this option thorugh VBA so that it can be
turned off and on depending on user security that I have set up?

 

[Scott McDaniel]

I would like the F11 key to work as well as the right click pop up menus. I
know I can build popup menus but this only works in form view and if I am
doing maintenance on a database it is a hassel to use the menu bars instead
of the pop up menus. I would have thought that under the
tools|options|check the Use Access Special Keys would have restored the
functionality.

F11 functionality should be restored by re-enabling the Use Special Keys option ... the others are (this from online
help):

Keys Result
------ ---------
F11 Brings the Database window (Database window: The window that appears when you open an Access database or
an Access project. It displays shortcuts for creating new database objects and opening existing objects.) to the front.

CTRL+G Brings up the Immediate window.

CTRL+F11 Toggles between the custom menu bar and the built-in menu bar.

CTRL+BREAK In a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL
Server database and is used to create client/server applications. A project file doesn't contain any data or
data-definition-based objects such as tables and views.), stops Access from retrieving records from the server.

ALT+F11 Starts the Microsoft Visual Basic Editor.


As you can see, re-enabling that option does nothing for your rightclick menus. I'd assume you'd need to re-enable some
combination of the Allow Full Menus, Allow Default Shortcut Menus, or Allow Built-in Toolbars to do that.

That said, I fail to see how building a simple popup menu that only you can open is a tedious task ... took me all of
about 5 minutes to build it using the Customize feature of the builtin toolbar ... this would do what you want, and
would make your maintenance tasks a lot easier.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com