Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / May 2008

Tip: Looking for answers? Try searching our database.

Opening

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
renegade39 - 06 May 2008 22:03 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.