DataBase - open database to input data

Asked By Ashley

20-Nov-09 11:08 AM

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?

20-Nov-09 11:34 AM

==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

20-Nov-09 11:32 AM

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 <Tools><Startup> menu to set the startup
conditions for your mdb.

-Ed

20-Nov-09 12:20 PM

Thank you both very much! Worked like a charm!

20-Nov-09 01:04 PM

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

Phil, London

20-Nov-09 03:12 PM

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

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

Answers/posts based on Access 2000/2003

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

21-Nov-09 07:58 AM

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