Design Question

[Pam]

I have an access database that I use for tracking complaints. It was designed
by an IT person who is no longer on staff here and we currently do not have
anyone who is as knowledgeable in Access. When he set it up, he designed the
forms so that the toolbars are not visible and there is no way to acess them.
The only option that shows is "exit." I know that there is a key stroke that
will let me get into the design mode so that I can make changes but I can not
remember what it is. Does anyone know the key stroke that will allow me to
get into the design mode of the database?
Thank you.

 

[fredg]

I have an access database that I use for tracking complaints. It was designed
by an IT person who is no longer on staff here and we currently do not have
anyone who is as knowledgeable in Access. When he set it up, he designed the
forms so that the toolbars are not visible and there is no way to acess them.
The only option that shows is "exit." I know that there is a key stroke that
will let me get into the design mode so that I can make changes but I can not
remember what it is. Does anyone know the key stroke that will allow me to
get into the design mode of the database?
Thank you.

Either Press F11 while the database is open,
OR..
Hold down the shift key when you open the database.

 

[Pam]

Thank you Fred for you quick reply. I had previously tried the shift key and
that does not work. I also just tried the F11 and it still opens it in a way
that the design function is not accessible. Any other suggestions?

 

[mscertified]

You could try creating a new empty Access database and import all the objects
into the new database. You will then be able to set up the new database to
allow the bypass key to get into development mode.

-Dorian

 

[fredg]

Thank you Fred for you quick reply. I had previously tried the shift key and
that does not work. I also just tried the F11 and it still opens it in a way
that the design function is not accessible. Any other suggestions?

The previous developer might have also set the "Use Access Special
Keys" to false, that's why F11 doesn't work.

Hold down the shift key and double-click on the database file's icon.
As far as I know, that's the only other way. Perhaps you can import
everything into a new database file as suggested by mscertified.

 

[Scott McDaniel]

I have an access database that I use for tracking complaints. It was designed
by an IT person who is no longer on staff here and we currently do not have
anyone who is as knowledgeable in Access. When he set it up, he designed the
forms so that the toolbars are not visible and there is no way to acess them.
The only option that shows is "exit." I know that there is a key stroke that
will let me get into the design mode so that I can make changes but I can not
remember what it is. Does anyone know the key stroke that will allow me to
get into the design mode of the database?
Thank you.

Is this an .MDE format? If so, you're pretty much out of luck in regards to altering the design of certain objects. You
can change Table and query design, but not Form/Report design.

If this isn't an .MDE format, then the ShiftKey may be disabled. You can try the freeware at the link below to reset the
ShiftKey; I've never used this utility so can't say for sure that it will work:

http://www.jamiessoftware.tk/propeditor/pe_download.html

Here's generic code that allows you to enable/disable the Shift key:

http://www.mvps.org/access/general/gen0040.htm



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

 

[chessMaster]

Pam, follow these steps

1. Press & hold Shift Key when opeing the database

2. Go to Tools - Startup
- Under Menu Bar, ensure that the "Allow Full Menus" option is checked.
Also, enable/check all the oother boxes.

3. Press OK. Close and restart the database.

4. You should not need to hold the Shift Key again. All menus should appear.

Let me know if this works for you.

Godwin

 

[chessMaster]

Pam,

also go to Tools - Security - User & Group Permissions.

Click on users and any names listed then under Permissions, check all the
boxes.

Godwin