Prompts Upon Opening

[Guest]

Is it possible for me to have a page appear upon opening the file which could
prompt for what a person wishes to do. For instance, on page that lists the
available features (ie: Search for Vendors, View Vendor Info, Enter
Information,etc.) Then (if possible) you could choose the task you wish to
perform and it would direct you to the right place (either a form, a query,
or a report).

This would be really helpful for my purpose. And a lot easier for those who
will be using my database. Let me know any helpful suggestions since I am
new at this.

 

[SusanV]

Use the switchboard, or create your own custom form and set it in Startup.

 

[Rick B]

You could use the built-in "switchboard manager" to build a switchboard.
You can access the switchboard manager through Tools/Database
Utilities/Switchboard Manager". Or, you could create your own form and
place buttons on the form that do what you wish. You can then place the
form in the Tools/Startup screen's "Display Form/Page" field.

 

[Al Camp]

AShearer,
Use the Tools/Startup/DisplayForm to indicate what form you want to open when the
database opens.
This is usually a form like a "Main Menu", where the user can opt whether to open a
another data form, or report, etc...

 

[Larry Linson]

Is it possible for me to have a page appear upon opening the file which
could
prompt for what a person wishes to do. For instance, on page that lists
the
available features (ie: Search for Vendors, View Vendor Info, Enter
Information,etc.) Then (if possible) you could choose the task you wish
to
perform and it would direct you to the right place (either a form, a
query,
or a report).

A "traditional" Access database opening screen, ever since the product was
introduced has been a Form with Command Buttons, showing the functions,
clicking which opens other Forms, and it has traditionally been called a
"switchboard form". If you first create the other Forms (the ones performing
the functions), the Command Button wizard will create the buttons for you,
including the code that opens the other forms.

Later, in a burst of enthusiasm, Microsoft created and has supplied with
each version of Access, a Switchboard Manager. This creates multiple forms
driven off a table, the operation of which is not "patently obvious to the
casual observer." In my view, the Switchboard Manager is a complex solution
to a simple problem, and the number of problems people report here in the
newsgroups confirm my view. So, though my colleagues have proposed this as a
possible solution to your problems, be aware that I think that an unbound
form with Command Buttons will be simpler in the first place, and have
potential for fewer problems in the long run.

Larry Linson
Microsoft Access MVP

 

[Al Camp]

Couldn't agree more... and well said!
Like Macros, Switchboards tend to insulate beginners from the power and flexibility of VB
module code.
Al Camp