Whats the bar at the bottom of the screen called?

[James Bowyer]

I only ask because I want to turn it off for certain users (so they can't turn off Filtering). It would seem I could do this using

DoCmd.Showtoolbar "Ribbon", acToolbarNo

Except replacing Ribbon with whatever the other bar is called.

Anyone know?

[Markus]

What bar? at the bottom of what screen? You'll have to give us a little context here. Typically a bar at the bottom of a window is the 'status' bar.

[James Bowyer]

this bar



With the Arrow buttons, filter buttons, etc.

[mshmyob]

I believe you are showing us the "Navigation Buttons". Just turn it off in the properties of the form or by vba code.

cheers.

[James Bowyer]

Unfortunately, when run in access, turning it off had no effect, and when run in runtime, caused it to crash.

Any idea what elese it might be called?

[NeoPa]

I don't use Access 2007 (It's always a good idea to furnish us with such information by the way), but in my experience this is relative to a form, rather than the application or even the OS. To control whether or not that shows up for any particular form, look to the form property called Navigation Buttons. If that's not working for you then either this is one of those areas where 2007 differs markedly from earlier versions (perfectly possible), or maybe you need to scan the 2007 Help on that property for more info on how to use it in that version.

[James Bowyer]

As usual Mr NeoPa, you seem to be correct! Any idea of the VBA code to turn them off? I tried

DoCmd.Showtoolbar "Navigation Buttons", acToolbarNo

and it didn't work.

[James Bowyer]

On second thoughts, don't worry. I have turned it off using the properties, and simply added next/previous buttons for admin users.

[NeoPa]

To be fair I think Mshmyob (post #4) beat me to it on this one James, but if you want programmatic access to it then it's via the form :

Me.NavigationButtons = [I]True / False[/I]

[James Bowyer]

Ah, different code to how I tried it! Oh well, did it a different way now anyway! Is there a shortcut key for disabling form filtering (such as Ctrl+F, although obviously not that), and if there is, how do I disable that too?

[NeoPa]

The property you're looking for (of the form again) is Allow Filters. In code it can be referenced as :

Me.AllowFilters = [I]True / False[/I]

There is no default setting I know for such a shortcut key, but keys can be configured in Access anyway, so you can grow your own if that's what you want.

[James Bowyer]

I think I might have been slightly unclear about what I wanted here, The form is opened filtered, and I want it to remain as such, without anyone being able to turn filtering off. Would that still achieve this?

[NeoPa]

Actually, I just checked and I can't find how you would configure shortcut settings, so either I'm remembering another application or it's not too easy to find in Access. Sorry.

[NeoPa]

Yes it would still allow that. Check out the Help for this property. You will see in the notes part that it doesn't affect the Filter or FilterOn properties. What it should say is that it affects only the interface for the operator.