hide/show database window via visual basic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to programmatically (VB) hide or show the database window. How can I
do this please?

Access2002.

Thanks!!
 
Public Sub HideDBWindow()

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

End Sub

Public Sub ShowDBWindow()

DoCmd.SelectObject acTable, , True

End Sub

Stuart
 
To hide use

docmd.RunCommand acCmdWindowHide

To show use
docmd.RunCommand acCmdWindowUnhide

Or, press the F11 key to unhide the database window
 
Thanks! It worked perfectly!

Stuart said:
Public Sub HideDBWindow()

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

End Sub

Public Sub ShowDBWindow()

DoCmd.SelectObject acTable, , True

End Sub

Stuart
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display database window 12
Programmatically selecting an item in a Listbox 2
compiler error 1
system object 4
hiding tables.... 3
Controlling the Database Window 3
Database Window Visible 2
Hide All Windows 8

Back
Top