open database to input data

[Ashley]

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?

 

[Ed Robichaud]

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

 

[John Spencer]

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

Thank you both very much! Worked like a charm!

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

.

 

[Philip Herlihy]

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

 

[Philip Herlihy]

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