Why can't I permanently hide the navigation pane?

[boblarson]

Glad we could get it sorted for you.

 

[FraserC]

thanks for this guys - just what I needed!~

 

[boblarson]

I am experiencing the same problem. Has anyone got a solution for this yet?

Cheers
Fraser

Yes, the solution was in post #18 which I gave the solution as a sample file.

 

[FraserC]

Yes, the solution was in post #18 which I gave the solution as a sample file.

sorry bob - hadn't made it page 2 before I posted. You replied before I even managed to edit my post! Cheers

 

[boblarson]

sorry bob - hadn't made it page 2 before I posted. You replied before I even managed to edit my post! Cheers

We aim for quick service

 

[FraserC]

haha, awesome

 

[FraserC]

Hi Bob (and others).

I seem to have a slightly different problem. I'm developing an app that will be distributed as an ACCDE. I've written code to disable the bypass key, but can't seem to prevent users from just pressing F11 to reveal the navigation pane. I tried putting the following in the load event of my splash screen, but it made no difference:

DoCmd.LockNavigationPane (True)

Then, based on Bob's fix above, I also pasted in the following code just beneath.

DoCmd.ShowToolbar "Ribbon", acToolbarNo

However, users can still press F11 to show the navigation pane. Also, I have a custom built ribbon, which was not visible after this code was run.

Can anyone please tell me how to permanently hide the navigation pane while still allowing ribbons?

Thanks for any help - much appreciated.

Cheers
Fraser

 

[boblarson]

For the F11 key you uncheck the USE ACCESS SPECIAL KEYS under the CURRENT DATABASE options in Access Options.

 

[boblarson]

And as for the ribbons, I'm not 100% sure about that, because I think disabling the QAT is the issue and that hangs around if you have any ribbons.

 

[FraserC]

thanks Bob. Unchecking special access keys did the trick, but users can still reset it by going back into the access options.

Will keep searching - thanks again.

 

[boblarson]

thanks Bob. Unchecking special access keys did the trick, but users can still reset it by going back into the access options.

Will keep searching - thanks again.

The Disable Bypass Key should keep them out of Access Options.

 

[FraserC]

oddly enough, it doesn't!

 

[boblarson]

oddly enough, it doesn't!

Well, if you make it into an ACCDE then it will.

 

[FraserC]

nope, its still there! Just reading a thread elsewhere, which talks about disabling commands underneath the office button. Will post once I find the answer!

 

[CraigDolphin]

I have barely touched Access 2007 but this source ( http://msdn.microsoft.com/en-us/library/bb258192(office.12).aspx ) seems to indicate that you can't disable the ribbon entirely, at least, it seems like maybe you have to replace it with a customized ribbon instead? (so I wonder if you can create a blank ribbon for use instead?)

Maybe I'm wrong about this but since it's a micro$oft article, I thought I'd throw it into the mix.

 

[FraserC]

This got me pretty close, but didn't disable "access options". So close!~!

 

[boblarson]

I have barely touched Access 2007 but this source ( http://msdn.microsoft.com/en-us/library/bb258192(office.12).aspx ) seems to indicate that you can't disable the ribbon entirely, at least, it seems like maybe you have to replace it with a customized ribbon instead? (so I wonder if you can create a blank ribbon for use instead?)

Maybe I'm wrong about this but since it's a micro$oft article, I thought I'd throw it into the mix.

You can disable the Ribbon entirely (my attachment shows you can), but the problem is that the OP NEEDS the Ribbon. The reason my attachment got rid of the ribbon is to also get rid of the Quick Access Toolbar (QAT) which is there as long as a Ribbon is there.

 

[FraserC]

This got me pretty close, but didn't disable "access options". So close!~!

oops. forgot to add the link:

http://www.utteraccess.com/forum/lofiversion/index.php/t1933390.html

(apologies for posting a thread from another forum)

 

[boblarson]

This got me pretty close, but didn't disable "access options". So close!~!

Sorry, I was wrong - it is the checkbox ALLOW DEFAULT MENUS that needs to be unchecked to keep the Access Options from being available.

 

[FraserC]

YUSSS!

That did it - thanks so much Bob. What a legend!!