How To Open A Form When I Open The Database

[nouveauricheinvestments]

How do I open a form when I open the database?

 

[Jeff Boyce]

If you are asking how to get Access to automatically start with a particular
form when it opens a database, that will depend on which version of Access
you are using.

If you are meaning literally, how do YOU open a form, do you mean in design
view or in form view?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ryan]

Go to Tools, Startup..., and in there ther is a Display Form/Page dropdown.
Select your from from that list and when your application opens that form
will open.

 

[nouveauricheinvestments]

Go to Tools, Startup..., and in there ther is a Display Form/Page dropdown.
Select your from from that list and when your application opens that form
will open.

I'm using Access 2007. I built a form from which a user can select a
series of options. All options are grayed out until the user selects
the Sign In option. I need to make this form automatically open when
the user starts the database. Or would it be better to use a
switchboard manager? I don't really know anything about
switchboards. I sort of like my current setup.

So back to the original question. I don't see a Tools->Startup.

 

[nouveauricheinvestments]

I'm using Access 2007. I built a form from which a user can select a
series of options. All options are grayed out until the user selects
the Sign In option. I need to make this form automatically open when
the user starts the database. Or would it be better to use a
switchboard manager? I don't really know anything about
switchboards. I sort of like my current setup.

So back to the original question. I don't see a Tools->Startup.

Okay I found the option to have a startup form. My other question
would be how do I disable the access objects view when the database is
opened and after I split the database all I see is a back end. The
front end looks the same - am I supposed to delete the tables out of
the front end to make it a legitimate 'front end database'?

 

[Jeff Boyce]

The notion of a "split" database is that the data is in ONE place only, the
"back-end".

The "front-end" contains all the Access objects EXCEPT the data ... but it
"sees" the data by linking to it. Thus, the front-end still looks like it
has tables, but they are only links.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[nouveauricheinvestments]

The notion of a "split" database is that the data is in ONE place only, the
"back-end".

The "front-end" contains all the Access objects EXCEPT the data ... but it
"sees" the data by linking to it.  Thus, the front-end still looks likeit
has tables, but they are only links.

Regards

Jeff Boyce
Microsoft Office/Access MVP

oh very interesting. Thank you for the clarification. I was just
about to pull a 'let's see what happens' move and delete the tables.
Thank you for saving me some heartache.

 

[Jeff Boyce]

A generally-good practice with any program, not just Access, is to make a
backup copy before doing anything that could change data...

I figure if it will cause me to tear out my hair and swear if I lose what I
have (now), NOW is a good time to backup...

Regards

Jeff Boyce
Microsoft Office/Access MVP

The notion of a "split" database is that the data is in ONE place only,
the
"back-end".

The "front-end" contains all the Access objects EXCEPT the data ... but it
"sees" the data by linking to it. Thus, the front-end still looks like it
has tables, but they are only links.

Regards

Jeff Boyce
Microsoft Office/Access MVP

oh very interesting. Thank you for the clarification. I was just
about to pull a 'let's see what happens' move and delete the tables.
Thank you for saving me some heartache.