disabling a toolbar

[JohnE]

Is there a way (programatically) to disable or make invisible the UNDO and
REDO buttons in the "Customize Quick Access Toolbar"? If so what would it be?
Using Access 2007.
Thanks.
.... John

 

[Albert D. Kallal]

Is there a way (programatically) to disable or make invisible the UNDO and
REDO buttons in the "Customize Quick Access Toolbar"? If so what would it
be?
Using Access 2007.
Thanks.
... John

You can turn off and hide the whole ribbon with:
DoCmd.ShowToolbar "Ribbon", acToolbarNo

And, you can disable the whole QAT.

I suppose if you need SOME options on the QAT, then you can build own custom
one (so, just leave out the undo option then).

Here is a link that explains this:

http://www.accessribbon.de/en/index.php?Access_-_Ribbons:Ribbon_XML___Controls:QAT


I about 85% sure that you can't enable/disable individual options on the
QAT. the above is a work-around in that you can make your own QAT, or
perhaps just hide it all together....

 

[JohnE]

Mr. Kallal, the docmd line works. But, is there a way to have just the QAT
hide/remove and leave everything else?
Thanks.
.... John

 

[Albert D. Kallal]

According to that link, you have to create your own custom ribbon if you
want the qat hidden.

So, one approach would be to be build a basic ribbon with the basic edit/cut
copy paste groups that you need.

I mean, once you go down the road of trying to hide all these bits and
pieces, you are taking the road of a custom UI..so, just go build that
custom interface....