Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Prompts Upon Opening

Discussion in 'Information Technology' started by AShearer, Jul 28, 2006.

  1. AShearer

    AShearer
    Expand Collapse
    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.
     
  2. Loading...


  3. SusanV

    SusanV
    Expand Collapse
    Guest

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

    "AShearer" <AShearer@discussions.microsoft.com> wrote in message
    news:FD5C5AB7-15C2-43E3-BEF9-6D0125133D9B@microsoft.com...
    > 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.
     
  4. Al Camp

    Al Camp
    Expand Collapse
    Guest

    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...
    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions

    "AShearer" <AShearer@discussions.microsoft.com> wrote in message
    news:FD5C5AB7-15C2-43E3-BEF9-6D0125133D9B@microsoft.com...
    > 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.
     
  5. Rick B

    Rick B
    Expand Collapse
    Guest

    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.


    --
    Rick B



    "AShearer" <AShearer@discussions.microsoft.com> wrote in message
    news:FD5C5AB7-15C2-43E3-BEF9-6D0125133D9B@microsoft.com...
    > 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.
     
  6. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "AShearer" <AShearer@discussions.microsoft.com> wrote in message
    news:FD5C5AB7-15C2-43E3-BEF9-6D0125133D9B@microsoft.com...
    > 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
     
  7. Al Camp

    Al Camp
    Expand Collapse
    Guest

    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

    "Larry Linson" <bouncer@localhost.not> wrote in message
    news:%235KxX%23dpGHA.524@TK2MSFTNGP05.phx.gbl...
    >
    > "AShearer" <AShearer@discussions.microsoft.com> wrote in message
    > news:FD5C5AB7-15C2-43E3-BEF9-6D0125133D9B@microsoft.com...
    >> 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
    >
     

Share This Page