Hiding/Unhiding the Database Window (Access 97 SR2)

Topic

New Reply

At the startup of our database, I have unchecked the Display Database Window option in the Startup dialog box. I also want to prevent users from using the shift key to open the database window when opening the database. But, I want to be able to open the database window. What I would like to do is when I log in to the database there is code that automatically opens the database window. I have read Access Help on the subject but I don’t really understand it. Is there a simple way to do this? If I haven’t explained my needs clearly, let me know.

Thanks.

Reply | Quote

Replies

The simplest way to handle it is to put a transparent button on your switchboard or whatever startup form you use and put the code to unhide the database window in the button’s onclick event. You can simply put a line like this in that event procedure:

DoCmd.SelectObject acForm, Me.Name, True

Which tells it to select the current form object in the database window.

Reply | Quote

Thanks, Charlotte. Your recommendation gets me part of the way there. I placed a transparent button on the opening form and placed the code in the event procedure. I opened the database and clicked on the button. It did open the database window and highlighted the opening form, but since the opening form stayed open, the database window was frozen until I closed the opening form. So, I guess I will add a close form command on the button. That should take care of that part.

The other thing I really need to do is to completely disable the shift key so that it can’t be used to open the database window. Can that be done? Or, should that be done? I just don’t want anyone to be able to open the database window, period.

Reply | Quote

[indent]

---

. It did open the database window and highlighted the opening form, but since the opening form stayed open, the database window was frozen until I closed the opening form

---

[/indent]This sounds a bit like a Burns and Allen routine (say goodnight, Gracie). Normally, you do this with the current form only when you are closing that form. Otherwise, pick another form or a table that will always be there and use that. I don’t allow the database window to be opened except from my backdoor button on the switchboard, and the same routine closes the switchboard.

Yes, it can be done. I’ll leave the should part up to you. If you do a search on database window in this forum, you’ll find previous discussions on this subject.

Reply | Quote