Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Anyway to disable Quick Access Toolbar in Access 2010 with code?

Status
Not open for further replies.

LittleNick

Technical User
Jun 26, 2009
55
US
Good Morning,

Is there a way to disable Quick Access Toolbar so that users can not add commands that allow them to access the design of forms/reports or data (delete)?

Thank you.
 
Are you rolling out copies of the ACCDB as your application?

Try using ACCDE or better still ACCDR with the runtime.

Saves money on needing Office with Access for every user and also locks the application down to a user runnable version only.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music
 
Here are examples of how I am hiding and unhiding the navigational bar and ribbon.

Function SecureProperties()
' Hide Navigation Panel
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide

' Hide Ribbon
DoCmd.ShowToolbar "Ribbon", acToolbarNo

End Function

Function UnSecureProperties()
' Show Navigation Panel
DoCmd.SelectObject acTable, , True

' Show Ribbon
DoCmd.ShowToolbar "Ribbon", acToolbarYes

End Function
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top