how can I remove quick access toolbar from the application I develop

[sun50]

I develop a simple application programme using access 2007. I have succeeded in removing the tabs and ribbon. I now wanted to get rid of the quick access toolbar so that no body can access the access option to change any thing from my database. Please help me, how can I do it?

Thanks.

[zmbd]

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Takes care of the Ribbon and the QAT; however, you'll also want a way to re-enable these if you get stuck.

[NeoPa]

I'm guessing the QAT and the Ribbon are separate items from the question Z. Your post seems to handle the Ribbon (which the OP has already handled). Is there something else for the QAT, or does that command do both?

[TheSmileyCoder]

That command will do both (atleast when tested in 2010)

[zmbd]

NeoPa, as per TheSmileyCoder; the code will take care of both and will work for both V2007 (verfied by my Father-In-Law... poor guy, has V2007 :( ) and in V2010 as this is what I use to kill both QAT and Ribbon.

This line of code is also the only reliable way I've found to take the QAT out of action. I've ran across other means; however, simple crashes and goofs in code seemed to return the QAT wherein this one doesn't.

[TheSmileyCoder]

Note that this also means you cannot code a custom ribbon at the same time. I don't actually know if you can code menu commandbars, with the ribbon toolbar disabled.

[sun50]

please I do not still understand how to use the code to remove the riboon and quick access toolbar, can you please explain the procedure for me so that I can try it.
Thanks.

[NeoPa]

The exact code is given in post #2. What is it that you don't understand?

[zmbd]

You can call this in several ways:
From a startup form
From a statup macro
<ctrl><g> and then cut and paste, press enter; however, this will only hold true for that session. - Nice to troubleshoot with as you can close and reopen to get back your tool bars if something goes horribly wrong.

You can also go this route: Customize the Ribbin

Sounds like may be after something different like making the database MDE/ACCDE.



[Z{edit: Just another MS site; however, deals with the topic from v2010 Deploying a Customized Ribbon and Quick Access Toolbar in Office 2010 }]