How to hide database window with VB?

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

I know I can hide database window in "Start up..." option,but if you
minimize it,you will find two icons in task bar,then if you click the Access
icon,the database window will display.

I can use VB to set form's visible as false,but I didn't know the name of
the database window in VB?
Could you tell me?

Thanks in advance.

Aaron _~@
Yang _`\<,_
¡¡ (*)/&(*)
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
 
Aaron said:
I know I can hide database window in "Start up..." option,but if you
minimize it,you will find two icons in task bar,then if you click the Access
icon,the database window will display.

I can use VB to set form's visible as false,but I didn't know the name of
the database window in VB?
Could you tell me?
Click to expand...

You can't refer to the window itself, but if you select an object and then run
the hide window command the result is the same.

DoCmd.SelectObject acTable,"SomeTable", True
DoCmd.RunCommand acCmdWindowHide
 
Hi,Rick,

Thank you very much!

But I don't think it is perfect to solve it,as you code,the database window
will show very quickly,the display time is very short,but end user can see
it.

How about you think?

I just think I could add code in main window load event,such as below:

forms![FORM].visible=false

My problem is that how can I express database window in VB.



Aaron _~@
Yang _`\<,_
¡¡ (*)/&(*)
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
 
Aaron said:
Hi,Rick,

Thank you very much!

But I don't think it is perfect to solve it,as you code,the database window
will show very quickly,the display time is very short,but end user can see
it.
Click to expand...

I thought you were looking for a way to hide when it was already showing.
 
Aaron said:
I know I can hide database window in "Start up..." option,but if you
minimize it,you will find two icons in task bar,then if you click the Access
icon,the database window will display.
Click to expand...

That is not correct.

If you hide the database window, and also un-check the option to Use access
special keys. This will keep the ms-access window hidden. You also need to
specify a start-up form also. You also want to set/change ms-access to NOT
show each window in the task bar. So, also change tools->options->un-check
windows in task bar.

Doing the above should hide everything.

Try download my sample mdb with the access interface hidden. You then take a
look at the settings I used. There is/was NO code required.

Check out the 3rd download at:
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
 
Back
Top