How To Open A Form When I Open The Database

  • Thread starter Thread starter nouveauricheinvestments
  • Start date Start date
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
 
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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

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'?
 
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
 
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
Click to expand...

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.
 
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
Click to expand...

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.
 
Back
Top