remove all toolbar options

[Guest]

I have created an MDE version of my front end MDB 2003 format database.
I have used startup options to remove all the menu bars but would also like
to remove the main one which has File, Edit, View etc. The users do not need
these and I want to avoid them using things like Record, Add new or Record,
Goto as I know this will cause problems.

Any help greatly appreciated.

 

[Arvin Meyer [MVP]]

In the form's Load event use something like:

DoCmd.ShowToolBar "Menu Bar", acToolbarNo
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

Hi Arvin, thanks for the response.
You suggested the forms load event however I want this to apply to the
entire database. I tried creating a module but that seemed to fail on "Menu
Bar".
I have found the option to show or hide the Menu Bar in Options but when you
close and then re-open the database the menu bar re-appears.

Any other ideas?

 

[Rick Brandt]

Hi Arvin, thanks for the response.
You suggested the forms load event however I want this to apply to the
entire database. I tried creating a module but that seemed to fail
on "Menu Bar".
I have found the option to show or hide the Menu Bar in Options but
when you close and then re-open the database the menu bar re-appears.

Any other ideas?

Open your app as it is now and maximize a report. Notice that the buttons for
restore, minimize, and close are placed within the main menu bar. If your app
has no menu bar at all then anything that is maximized will be stuck there.
With forms you can include your own close button, but reports will have no way
to be closed if you don't provide them with some kind of toolbar or menu bar of
your own.

Just create your own menu bar with nothing on it except that which you feel
"safe" about and make that your app's main menu bar in the startup properties.

 

[Guest]

Thats just what I needed Rick. Thanks very much.

Open your app as it is now and maximize a report. Notice that the buttons for
restore, minimize, and close are placed within the main menu bar. If your app
has no menu bar at all then anything that is maximized will be stuck there.
With forms you can include your own close button, but reports will have no way
to be closed if you don't provide them with some kind of toolbar or menu bar of
your own.

Just create your own menu bar with nothing on it except that which you feel
"safe" about and make that your app's main menu bar in the startup properties.

 

[Arvin Meyer [MVP]]

If you hide it the menu on the first form you open, (like the startup form)
it will stay hidden until you enable it again.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com