Access Autoexec Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 18 Oct 2005 21:26 GMT

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.

Reply to this Message

Klatuu - 18 Oct 2005 21:53 GMT

Hold down the Shift key while you open the database file

> Hello,
>
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

Ofer - 18 Oct 2005 21:55 GMT

You can that to hide it
docmd.RunCommand acCmdWindowHide

Pressing F11 key will bring the window back

Signature

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

> Hello,
>
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

Ofer - 18 Oct 2005 22:10 GMT

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

Signature

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

> You can that to hide it
> docmd.RunCommand acCmdWindowHide
[quoted text clipped - 10 lines]
> >
> > Thanks.

Reply to this Message

Klatuu - 18 Oct 2005 23:21 GMT

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.

> Ignore my post, I misunderstood the question.
>
[quoted text clipped - 18 lines]
> > >
> > > Thanks.

Reply to this Message

Ofer - 18 Oct 2005 23:31 GMT

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.

Signature

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

> I wondered about your first post, but then I have never misunderstood or
> misread a post :)
[quoted text clipped - 24 lines]
> > > >
> > > > Thanks.

Reply to this Message