Database Window via Code

Hi all,

Can I display the database window via code? I wish to create a command button on a
form that would check for user name (already can do this part) and allow certain names
only to access the database window. I have already disabled all the options under startup
and have bypassed the "shift" key as well.

Thank you so much in advance!

BetsyBean

Use the DoCmd.SelectObject method
Example:

DoCmd.SelectObject acForm, , True

This will open the database window to the Forms Tab. You can specify which tab in the database window to display by changing the required Object Type to acTable to display the Table Tab or acQuery to display the Query Tab etc.

lwells

Thank you so much! It works perfectly for me. I certainly wish I had your expertise with Access