General user question

J

*Jill*

Hello,

I have a database and I'd like it so that a form pops up
when they open it and it hides the data and the users can
only see forms, how would I go about doing this.
I dont know too much about access.

On top of that, I have an older database in which just a
form opens but I cant see any of the data, how to I get
to see the data on databases like this, is it stored in
another file?! Any help would be appreciated, thanks.

Jill
 
B

Bob Wardlow

Jill;

To open a form on startup go to Tools, Startup, and put
the form you want to open in the "Display Form:" field. To
suppress the Database Window from opening uncheck
the "Display Database Window" checkbox in the same menu.

Good Luck,

Bob
 
L

Lynn Trapp

Jill,
There are 2 ways to do what you want. Under Tools > Startup you can select
a form that will open automatically when you open the database. Here you can
also see a choice to "Hide Database Window". This will prevent, sort of, the
users from getting to the data. The other way is to create a Macro named
AutoExec and open the form in that macro. The AutoExec macro runs when the
database opens.

If you hold down the Shift key while you open your database, all startup
options (including AutoExec macro) will be disabled. Of course, that is
unless the developer of the database has disabled the Shift key bypass.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top