Welcome to SPN

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

Sign Up Now!

Switchboard

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

Tags:
  1. Lalitha

    Lalitha
    Expand Collapse
    Guest

    For an existing database I designed a SQL query with parameter query. I also
    designed a form-startform with two unbound text boxes(text1 and text2) for
    start date and end date and these were used in parameter query. Before adding
    this query Switchboard will open first when I open the database, but now when
    I open the DB the list of objects are opened and I need to enter the start
    date and end date to open the switchboard form. Other forms open
    automatically. When I open the database I want the SB to be opened, It is
    already set as default page. I will appreciate the help very much.
     
  2. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Lalitha" <Lalitha@discussions.microsoft.com> wrote in message
    news:7D43062A-092A-4CFA-9FBC-E4BB0AFA5AB3@microsoft.com...
    > For an existing database I designed a SQL query with parameter query. I
    > also
    > designed a form-startform with two unbound text boxes(text1 and text2) for
    > start date and end date and these were used in parameter query. Before
    > adding
    > this query Switchboard will open first when I open the database, but now
    > when
    > I open the DB the list of objects are opened and I need to enter the start
    > date and end date to open the switchboard form. Other forms open
    > automatically. When I open the database I want the SB to be opened, It is
    > already set as default page. I will appreciate the help very much.


    Just designing and implementing a Form will not cause that Form to be opened
    at Startup. So, you must have changed the Tools | Startup options in the
    database window. Change them back to what they were before, and update your
    Switchboard to include a capability to open the Form from which you open the
    Query.

    Larry Linson
    Microsoft Access MVP
     
  3. Lalitha

    Lalitha
    Expand Collapse
    Guest

    Larry, I did not explain the problem clearly let me try again. The database
    was designed by another person with tables, forms, queries and a switchboard
    which opens when I open the database. All those queries have parameter
    queries linked to switchboard. When I tried the same method for my query SB
    is blank in form view. But design view was available. Suggestion was made to
    design a unbound form with two textboxes to define parameer query to enter
    start date and end date to my query.
    when i did that only the switchboard form(already designed by previous
    person) requires me to enter start date and end date in the
    dialogbox(designed by me). I need the swtch board to be opened without
    upsetting the previous setup, my query to run smoothly, and report of my
    query also to be run from a button on switch board. This little part ihave
    done successfully. Hope I am clear. I may be missing a small think. I am new
    to database design.

    Thank you for your help and appreciate very much.

    "Larry Linson" wrote:

    >
    > "Lalitha" <Lalitha@discussions.microsoft.com> wrote in message
    > news:7D43062A-092A-4CFA-9FBC-E4BB0AFA5AB3@microsoft.com...
    > > For an existing database I designed a SQL query with parameter query. I
    > > also
    > > designed a form-startform with two unbound text boxes(text1 and text2) for
    > > start date and end date and these were used in parameter query. Before
    > > adding
    > > this query Switchboard will open first when I open the database, but now
    > > when
    > > I open the DB the list of objects are opened and I need to enter the start
    > > date and end date to open the switchboard form. Other forms open
    > > automatically. When I open the database I want the SB to be opened, It is
    > > already set as default page. I will appreciate the help very much.

    >
    > Just designing and implementing a Form will not cause that Form to be opened
    > at Startup. So, you must have changed the Tools | Startup options in the
    > database window. Change them back to what they were before, and update your
    > Switchboard to include a capability to open the Form from which you open the
    > Query.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    >
    >
     
  4. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    You designed and implemented an unbound form with two textboxes -- that I
    understand. But what I said was this: designing and implementing that form
    will not cause the switchboard to automatically open that form.

    What did you do to the switchboard to make it open the form?

    Is this a switchboard created and modified by the Switchboard Manager, or is
    it just unbound Form(s) with Command Buttons and Text Boxes? (If it is
    handled via the Switchboard Manager, then someone else will have to
    assist -- I don't use the Switchboard Manager because it seems to me to be a
    complex solution to a simple problem and I don't use it.)

    Is this query truly a _parameter_ query? That is, does the Query itself
    refer to the Controls on your Form, or do you use VBA code to create a WHERE
    clause that you use in a DoCmd.OpenReport or other command?

    Do you want to expose the Query results directly to the user in Datasheet
    View (not generally a good idea)? Or is it enough that you use the values
    from the Text Boxes to limit the data shown on the Report?

    Larry Linson
    Microsoft Access MVP


    "Lalitha" <Lalitha@discussions.microsoft.com> wrote in message
    news:D91F091D-A0F3-4EDF-8C57-00269F131634@microsoft.com...
    > Larry, I did not explain the problem clearly let me try again. The
    > database
    > was designed by another person with tables, forms, queries and a
    > switchboard
    > which opens when I open the database. All those queries have parameter
    > queries linked to switchboard. When I tried the same method for my query
    > SB
    > is blank in form view. But design view was available. Suggestion was made
    > to
    > design a unbound form with two textboxes to define parameer query to enter
    > start date and end date to my query.
    > when i did that only the switchboard form(already designed by previous
    > person) requires me to enter start date and end date in the
    > dialogbox(designed by me). I need the swtch board to be opened without
    > upsetting the previous setup, my query to run smoothly, and report of my
    > query also to be run from a button on switch board. This little part ihave
    > done successfully. Hope I am clear. I may be missing a small think. I am
    > new
    > to database design.
    >
    > Thank you for your help and appreciate very much.
    >
    > "Larry Linson" wrote:
    >
    >>
    >> "Lalitha" <Lalitha@discussions.microsoft.com> wrote in message
    >> news:7D43062A-092A-4CFA-9FBC-E4BB0AFA5AB3@microsoft.com...
    >> > For an existing database I designed a SQL query with parameter query.
    >> > I
    >> > also
    >> > designed a form-startform with two unbound text boxes(text1 and text2)
    >> > for
    >> > start date and end date and these were used in parameter query. Before
    >> > adding
    >> > this query Switchboard will open first when I open the database, but
    >> > now
    >> > when
    >> > I open the DB the list of objects are opened and I need to enter the
    >> > start
    >> > date and end date to open the switchboard form. Other forms open
    >> > automatically. When I open the database I want the SB to be opened, It
    >> > is
    >> > already set as default page. I will appreciate the help very much.

    >>
    >> Just designing and implementing a Form will not cause that Form to be
    >> opened
    >> at Startup. So, you must have changed the Tools | Startup options in the
    >> database window. Change them back to what they were before, and update
    >> your
    >> Switchboard to include a capability to open the Form from which you open
    >> the
    >> Query.
    >>
    >> Larry Linson
    >> Microsoft Access MVP
    >>
    >>
    >>
     
  5. Lalitha

    Lalitha
    Expand Collapse
    Guest

    Thank you so much for your effort Larry. I found my mistake. I have selected
    the new query as the record sourse in the switchboard form by mistake. I have
    fixed every thing. Anyway by making a small mistake I have learned a lot.

    Thanks again,
    Lalitha.
    "Larry Linson" wrote:

    > You designed and implemented an unbound form with two textboxes -- that I
    > understand. But what I said was this: designing and implementing that form
    > will not cause the switchboard to automatically open that form.
    >
    > What did you do to the switchboard to make it open the form?
    >
    > Is this a switchboard created and modified by the Switchboard Manager, or is
    > it just unbound Form(s) with Command Buttons and Text Boxes? (If it is
    > handled via the Switchboard Manager, then someone else will have to
    > assist -- I don't use the Switchboard Manager because it seems to me to be a
    > complex solution to a simple problem and I don't use it.)
    >
    > Is this query truly a _parameter_ query? That is, does the Query itself
    > refer to the Controls on your Form, or do you use VBA code to create a WHERE
    > clause that you use in a DoCmd.OpenReport or other command?
    >
    > Do you want to expose the Query results directly to the user in Datasheet
    > View (not generally a good idea)? Or is it enough that you use the values
    > from the Text Boxes to limit the data shown on the Report?
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    >
    > "Lalitha" <Lalitha@discussions.microsoft.com> wrote in message
    > news:D91F091D-A0F3-4EDF-8C57-00269F131634@microsoft.com...
    > > Larry, I did not explain the problem clearly let me try again. The
    > > database
    > > was designed by another person with tables, forms, queries and a
    > > switchboard
    > > which opens when I open the database. All those queries have parameter
    > > queries linked to switchboard. When I tried the same method for my query
    > > SB
    > > is blank in form view. But design view was available. Suggestion was made
    > > to
    > > design a unbound form with two textboxes to define parameer query to enter
    > > start date and end date to my query.
    > > when i did that only the switchboard form(already designed by previous
    > > person) requires me to enter start date and end date in the
    > > dialogbox(designed by me). I need the swtch board to be opened without
    > > upsetting the previous setup, my query to run smoothly, and report of my
    > > query also to be run from a button on switch board. This little part ihave
    > > done successfully. Hope I am clear. I may be missing a small think. I am
    > > new
    > > to database design.
    > >
    > > Thank you for your help and appreciate very much.
    > >
    > > "Larry Linson" wrote:
    > >
    > >>
    > >> "Lalitha" <Lalitha@discussions.microsoft.com> wrote in message
    > >> news:7D43062A-092A-4CFA-9FBC-E4BB0AFA5AB3@microsoft.com...
    > >> > For an existing database I designed a SQL query with parameter query.
    > >> > I
    > >> > also
    > >> > designed a form-startform with two unbound text boxes(text1 and text2)
    > >> > for
    > >> > start date and end date and these were used in parameter query. Before
    > >> > adding
    > >> > this query Switchboard will open first when I open the database, but
    > >> > now
    > >> > when
    > >> > I open the DB the list of objects are opened and I need to enter the
    > >> > start
    > >> > date and end date to open the switchboard form. Other forms open
    > >> > automatically. When I open the database I want the SB to be opened, It
    > >> > is
    > >> > already set as default page. I will appreciate the help very much.
    > >>
    > >> Just designing and implementing a Form will not cause that Form to be
    > >> opened
    > >> at Startup. So, you must have changed the Tools | Startup options in the
    > >> database window. Change them back to what they were before, and update
    > >> your
    > >> Switchboard to include a capability to open the Form from which you open
    > >> the
    > >> Query.
    > >>
    > >> Larry Linson
    > >> Microsoft Access MVP
    > >>
    > >>
    > >>

    >
    >
    >
     

Share This Page