open database to input data

When a user opens the file for the database in Windows, how do we make it so
the form for inputting data is already pulled up, so the user will not have
to remember which form we want?

One of the easier methods is to use the AutoExec macro. Create a macro;
name it "autoexec"; then set its actions to open the form you want; and
maybe minimize the database window, hide the toolbars, etc. When the mdb is
opened, the autoexec macro is called and all its actions are run.

A slightly more involved approach would be to create a Switchboard type form
to serve as an on-screen menu. That form would have a series of command
buttons to open
your other forms and reports.

And perhaps lastly and easiest, most version of Access allow you to
designate a startup form. Use the ToolsStartup menu to set the startup
conditions for your mdb.

-Ed

"Ashley" wrote in message
news
When a user opens the file for the database in Windows, how do we make it
so
the form for inputting data is already pulled up, so the user will not
have
to remember which form we want?

==Open the database in design mode
==Select Tools: Startup
==Set Display Form/Page to the form you want to display when the database opens.


In Access 2007 (More steps - same result)
== Open the database in design mode
== Click on the Office button
== Click the Access Options button at the bottom of the window
== Click Current Database
== Set Display Form to the form you want to display when the database opens

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Ashley wrote:
When a user opens the file for the database in Windows, how do we make it so
the form for inputting data is already pulled up, so the user will not have
to remember which form we want?

Thank you both very much! Worked like a charm!

"John Spencer" wrote:

==Open the database in design mode
==Select Tools: Startup
==Set Display Form/Page to the form you want to display when the database opens.


In Access 2007 (More steps - same result)
== Open the database in design mode
== Click on the Office button
== Click the Access Options button at the bottom of the window
== Click Current Database
== Set Display Form to the form you want to display when the database opens

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Ashley wrote:
When a user opens the file for the database in Windows, how do we make it so
the form for inputting data is already pulled up, so the user will not have
to remember which form we want?
.

It's also worth noting that you can set a form property "Data Entry" so that
it's already waiting for input, rather than showing an existing record.

Phil, London

"Ashley" wrote in message
...
Thank you both very much! Worked like a charm!

"John Spencer" wrote:

==Open the database in design mode
==Select Tools: Startup
==Set Display Form/Page to the form you want to display when the database
opens.


In Access 2007 (More steps - same result)
== Open the database in design mode
== Click on the Office button
== Click the Access Options button at the bottom of the window
== Click Current Database
== Set Display Form to the form you want to display when the database
opens

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Ashley wrote:
When a user opens the file for the database in Windows, how do we make
it so
the form for inputting data is already pulled up, so the user will not
have
to remember which form we want?
.

Philip Herlihy wrote:
It's also worth noting that you can set a form property "Data Entry" so that
it's already waiting for input, rather than showing an existing record.

It's also worth noting that setting "Data Entry" to Yes means that you can
***only*** enter new records, you cannot view pre-existing records.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Quite right, and in fact I'd been thinking of something else: you can add a
line after "OpenForm" to the macro "GoToRecord", and in that action's
properties select "New" Record, and the form will open ready to accept a new
record, but still displaying the VCR controls to allow you to access
existing ones.

Phil

"Linq Adams via AccessMonster.com" u28780@uwe wrote in message
news:9f697fe02ecf8@uwe...
Philip Herlihy wrote:
It's also worth noting that you can set a form property "Data Entry" so
that
it's already waiting for input, rather than showing an existing record.

It's also worth noting that setting "Data Entry" to Yes means that you can
***only*** enter new records, you cannot view pre-existing records.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com