By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,140 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

How can i hide menu bar & restore it again?

P: 23
How can i hide menu bar & restore it again IN MS ACCESS DB ?
Nov 11 '13 #1

✓ answered by NeoPa

You can use :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarNo)
& :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarYes)
This can be done, but only if you have something starting automatically when the database opens.

I never use or recommend the use of macros, so that leaves a form. Each form can potentially have an Open event handler. Put the code in there.

Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,186
You can use :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarNo)
& :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarYes)
Nov 11 '13 #2

P: 23
Thanks to you friend. Actually I am new in MS ACCESS. I want whenever I enter in my database, menu bar should not show. Please tell me where should I place this code provided by you.....
Nov 12 '13 #3

NeoPa
Expert Mod 15k+
P: 31,186
You can use :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarNo)
& :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.ShowToolbar(ToolbarName:="Menu Bar", Show:=acToolbarYes)
This can be done, but only if you have something starting automatically when the database opens.

I never use or recommend the use of macros, so that leaves a form. Each form can potentially have an Open event handler. Put the code in there.
Nov 12 '13 #4

P: 23
Thanks a lot friend. Now it works.....
Nov 13 '13 #5

Post your reply

Sign in to post your reply or Sign up for a free account.