Access Autoexec Form

A

Adam

Hello,

I have a form that automatically opens when the database opens. Does anybody
know how to get to the database control window. I can see it sticking out
from behind the form (doesn't take up entire screen) but i can edit the
design and queries that need to be. I previously used one of the Function
keys but forgot wich one...??

Thanks.
 
O

Ofer

You can that to hide it
docmd.RunCommand acCmdWindowHide

Pressing F11 key will bring the window back
 
O

Ofer

Ignore my post, I misunderstood the question.

One way will be, as Klatuu suggested, but if the form is already open then,
I usually open the immidiate window (press ctrl+g) and type

Forms(0).visible = false
Assuming that it is the first form
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
K

Klatuu

I wondered about your first post, but then I have never misunderstood or
misread a post :)
Your ctrl+g idea is good, but I don't think it would work if the open winow
is Modal. I am not sure, but based on his description of the problem, it
looks like it may be a modal form.
 
O

Ofer

In Access 97 or Access 2.0 before the code was seperated, I used that to
solve the problem of pop up or modal forms, when I had a code break under a
pop up form, the only way to access this code or to see the full code without
the form in your way, was to make the form not visible, and this is when I
started using it.

--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
Top