How can I set my database so that when I open the database a form will
automatically pop-up. I need to have one particular form pop-up evertime
that my database opens. Please help. Thanks.
Jeff Boyce - 06 May 2008 22:19 GMT
Tools | Startup (exactly where depends on version of Access)
Regards
Jeff Boyce
Microsoft Office/Access MVP
> How can I set my database so that when I open the database a form will
> automatically pop-up. I need to have one particular form pop-up evertime
> that my database opens. Please help. Thanks.
renegade39 - 07 May 2008 01:11 GMT
I have access 2007
> Tools | Startup (exactly where depends on version of Access)
>
[quoted text clipped - 6 lines]
> > automatically pop-up. I need to have one particular form pop-up evertime
> > that my database opens. Please help. Thanks.
Jeff Boyce - 07 May 2008 15:55 GMT
Click the "Office" button (also affectionately known as the "belt buckle" in
the upper left corner).
Click the <Access Options> button at the bottom of the Office window that
popped up.
Select "Current Database".
Select the form you want to start with in the "Display Form" control.
Regards
Jeff Boyce
Microsoft Office/Access MVP
>I have access 2007
>
[quoted text clipped - 9 lines]
>> > evertime
>> > that my database opens. Please help. Thanks.
Dustin B - 06 May 2008 22:20 GMT
The easiest way to do this is to make a mcr that has an openform in it
pointing to the form you want to open. When you save the Macro call is
AutoExec. Any macro named autoexec will executive automatically when the DB
opens.
> How can I set my database so that when I open the database a form will
> automatically pop-up. I need to have one particular form pop-up evertime
> that my database opens. Please help. Thanks.
Dustin B - 06 May 2008 22:22 GMT
I just read the post mcr is Macro.
> The easiest way to do this is to make a mcr that has an openform in it
> pointing to the form you want to open. When you save the Macro call is
[quoted text clipped - 4 lines]
> > automatically pop-up. I need to have one particular form pop-up evertime
> > that my database opens. Please help. Thanks.
Beetle - 06 May 2008 22:21 GMT
You don't say what version of Access you have, but using 2003 as an
example, you would go to Tools/Startup/Display Form and select your
form there.
Alternatively, you could create a macro named AutoExec and use that to
open the form.

Signature
_________
Sean Bailey
> How can I set my database so that when I open the database a form will
> automatically pop-up. I need to have one particular form pop-up evertime
> that my database opens. Please help. Thanks.