NavigationPart

[Erwin Bormans]

Hi all

I've made an database with a switchboard.

Within the options of Access you can say that the navigationpart must not be
shown. Also all the editing toolbars can be hidden.

So I want this standard hidden that a normal user cannot edit or change
things, only uses the forms and reports available.

On my switchboard I've got a button 'Go to Database' Wich is meant for the
users that do no Access and want to make aditional forms, querys or reports.

Is there an easy way to say that he must show the navigation pannel and edit
toolbars again? So I'm searching for the vba code to change the properties
of access, conserning the current database.

Kind regards
Erwin

 

[Allen Browne]

For the names to use for setting the global options, see:
http://msdn2.microsoft.com/en-us/library/Aa140014(office.10).aspx
That article is for A2000, but the old names are the same.

Some of hte new names (such as "Show Navigation Pane Search Bar") are shown
here:
http://allenbrowne.com/ser-69.html

I've actually had difficutly in getting Access to show/hide the Navigation
Pane in A2007. In previous versions, we used SelectObject with True for the
last argument to show the db window.