Hiding a database window.

I am facing a problem in using

ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, True
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, True
ChangeProperty "AllowBypassKey", dbBoolean, True

For my tool , I have two levels of users general and Admin.
I want the database window to display if I login as Admin and hide for the general user.
But If Use the above set of commands...they are reflected only when open it next time...and also..when I go to file menu and click on that again it opens with a DB window....

I need to do this by coding not setting directly on the startup in tools...
Please  help me...if there is a way to achieve both hide and show in the same session if I login as a different user...
Who is Participating?
Elad22Connect With a Mentor Commented:
You can solve it in two ways:
1. You can remove the checkbox sign in the Menubar Options - > Startup.
2. You can use the command Docmd.MenuItem and do that by code.

Good luck!
You can use "DoCmd.RunCommand acCmdWindowUnhide" this will bring up the hidden windows.  You them pick which window to unhide.

This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.

Thank you,
Moderator @ Experts Exchange
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.