Link to home
Start Free TrialLog in
Avatar of Chintu
Chintu

asked on

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...
Thanx
Chintu
Avatar of jdesharnais
jdesharnais

You can use "DoCmd.RunCommand acCmdWindowUnhide" this will bring up the hidden windows.  You them pick which window to unhide.
ASKER CERTIFIED SOLUTION
Avatar of Elad22
Elad22

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
GREETINGS!

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.

https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
 
Thank you,
Moondancer
Moderator @ Experts Exchange