Access 2007 - disabling shift key and hiding DB window

[P_Henry]

Hi,

I have a couple of databases set up with shift key bypass and DB window hide and a couple of menu bar commands hidden (All code taken from this great forum ). Recently my company decided to upgrade Access 2000 to Access 2007 and they have given me a test environment and a time frame to convert / test all my applications.
I found this concept of ribbon and office links very different and shocking.
Is there a way of hidding somethings that you can do with the office links (like compact and repair) and a way of hiding some clusters in the ribbon (like export and import data, have a dtaasheet view of any form? etc) Any help or link along these lines would be helpful..
Thanks,
Priya

 

[boblarson]

You can create your own ribbons and here's a great tool to let you do it easily (and it is free):

http://www.ribboncustomizer.clatonh.com/

 

[P_Henry]

Thanks Bob..will try.

Priya

 

[padlocked17]

I think you can get rid of the navigation pane and also the default menu options from the Access Options after clicking the Windows Looking Icon in the top left corner.

I think customizing the ribbons however, is an awesome addition to Access. Should be very nice.

 

[P_Henry]

Hi Russ,

I did get rid of the ribbon by deselecting the following checkboxes in the 'Current Database ' tab under the Office links as you mentioned:

Allow full menus
Allow default shortcut menus
Allow built in tool bars.

Once disabled, how do I enable it back?
Can this be done programmatically using VBA? i.e have a spot on the form with a command button which when clicked asks for a password to let you see the navigation pane and the office icon?

Thanks,
Priya

 

[padlocked17]

I don't think it can be done with code honestly. To get them back you need to hold down Shift when double clicking your database and you should get all of your menus back and can go back to the prefs to reenable them.

I feel as if the DB has to be restarted to gain the functionality back, but I'm pulling this from memory, so I could quite easily be wrong.

 

[boblarson]

Actually, you can do all of that with code, but I can't give you specifics right now as I don't know it without seeing it.

However, there have been posts here and on Utter Access regarding this so a little searching with the search feature and/or Google would probably be in order.

 

[padlocked17]

Yep, found it after I open my mouth, er, typed my thoughts.

http://office.microsoft.com/en-us/access/HA012327191033.aspx
http://office.microsoft.com/en-us/access/HA012327161033.aspx

CurrentDb.Properties("AllowFullMenus") = True
CurrentDb.Properties("AllowBuiltInToolBars") = True

This feature will come in handy!