Welcome to SPN

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

Sign Up Now!

Is it possible?

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

Tags:
  1. an

    an
    Expand Collapse
    Guest

    Hi!
    I have one form based in query that asks for the option, in a set of 20
    options that are fixed.

    I would like, instead of having to write the option, to open one auxiliar
    form with command buttons each one with one of these 20 options, and with
    click in one of the buttons, to make to run this query for form to assist and
    open it.

    Is it possible?

    Thanks in advance.
    an
     
  2. Loading...

    Similar Threads Forum Date
    Movies Ashdoc's movie review---Mission impossible 5 Rogue nation Theatre, Movies & Cinema Aug 12, 2015
    India Professor Bhullar's release possible after landmark SC judgement Breaking News Jan 21, 2014
    USA UPDATED! Dr. Prabjot Singh, Sikh Professor Attacked in Possible Hate Crime (2 Videos) Breaking News Sep 23, 2013
    A Shabad I came across - possible interpretations Sikh Sikhi Sikhism Aug 28, 2013
    To know God is to Love him, why this is not possible Sikh Sikhi Sikhism Mar 31, 2012

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Please explain exactly what these "20 options" are. Building a form with 20
    buttons (each of which will open the same query, but with a different
    option) does not seem like a very good way to have a user run a query.



    --
    Rick B



    "an" <an@discussions.microsoft.com> wrote in message
    news:93FB5792-9AC2-4E27-8B7C-8A81B5CF6E31@microsoft.com...
    > Hi!
    > I have one form based in query that asks for the option, in a set of 20
    > options that are fixed.
    >
    > I would like, instead of having to write the option, to open one auxiliar
    > form with command buttons each one with one of these 20 options, and with
    > click in one of the buttons, to make to run this query for form to assist
    > and
    > open it.
    >
    > Is it possible?
    >
    > Thanks in advance.
    > an
     
  4. Svetlana

    Svetlana
    Expand Collapse
    Guest

    You could do it using toggle buttons instead.
     
  5. an

    an
    Expand Collapse
    Guest

    Thanks for your reply.

    My idea is:
    1 - Each button to run the query filled with option x/20, writed in clicked
    cmd.
    But only one form, based in selected query trought button clicked.

    Or

    2 - With 20 queries and each button to run distinct query but only one form
    based on choosed selected trought respective button.

    an

    "Rick B" wrote:

    > Please explain exactly what these "20 options" are. Building a form with 20
    > buttons (each of which will open the same query, but with a different
    > option) does not seem like a very good way to have a user run a query.
    >
    >
    >
    > --
    > Rick B
    >
    >
    >
    > "an" <an@discussions.microsoft.com> wrote in message
    > news:93FB5792-9AC2-4E27-8B7C-8A81B5CF6E31@microsoft.com...
    > > Hi!
    > > I have one form based in query that asks for the option, in a set of 20
    > > options that are fixed.
    > >
    > > I would like, instead of having to write the option, to open one auxiliar
    > > form with command buttons each one with one of these 20 options, and with
    > > click in one of the buttons, to make to run this query for form to assist
    > > and
    > > open it.
    > >
    > > Is it possible?
    > >
    > > Thanks in advance.
    > > an

    >
    >
    >
     
  6. Rick B

    Rick B
    Expand Collapse
    Guest

    I still don't understand. What does, "run the query filled with option
    x/20" mean?

    Do you have 20 fields that all contain the same type of data, and you don't
    know which field it will be in? In other words, could a value appear in any
    one of the 20 fields? If so, your data structure is wrong.

    Please give a real example. What are the names of the fields and what is
    the user typing in one of them?

    --
    Rick B



    "an" <an@discussions.microsoft.com> wrote in message
    news:7598C2F9-5306-44CE-ADA5-06869A59026F@microsoft.com...
    > Thanks for your reply.
    >
    > My idea is:
    > 1 - Each button to run the query filled with option x/20, writed in
    > clicked
    > cmd.
    > But only one form, based in selected query trought button clicked.
    >
    > Or
    >
    > 2 - With 20 queries and each button to run distinct query but only one
    > form
    > based on choosed selected trought respective button.
    >
    > an
    >
    > "Rick B" wrote:
    >
    >> Please explain exactly what these "20 options" are. Building a form with
    >> 20
    >> buttons (each of which will open the same query, but with a different
    >> option) does not seem like a very good way to have a user run a query.
    >>
    >>
    >>
    >> --
    >> Rick B
    >>
    >>
    >>
    >> "an" <an@discussions.microsoft.com> wrote in message
    >> news:93FB5792-9AC2-4E27-8B7C-8A81B5CF6E31@microsoft.com...
    >> > Hi!
    >> > I have one form based in query that asks for the option, in a set of 20
    >> > options that are fixed.
    >> >
    >> > I would like, instead of having to write the option, to open one
    >> > auxiliar
    >> > form with command buttons each one with one of these 20 options, and
    >> > with
    >> > click in one of the buttons, to make to run this query for form to
    >> > assist
    >> > and
    >> > open it.
    >> >
    >> > Is it possible?
    >> >
    >> > Thanks in advance.
    >> > an

    >>
    >>
    >>
     
  7. an

    an
    Expand Collapse
    Guest

    Sorry.

    For example:

    I have 12 months.
    The query ask me [what the month?]
    I write: JANUARY or FEBRUARY or another to DECEMBER (n/12)
    I would like to click on respective button (in auxiliar form) to fill the
    query, to run it, and to open ONE form based in this "conditional" query.

    I don't know if is possible...

    an

    "Rick B" wrote:

    > I still don't understand. What does, "run the query filled with option
    > x/20" mean?
    >
    > Do you have 20 fields that all contain the same type of data, and you don't
    > know which field it will be in? In other words, could a value appear in any
    > one of the 20 fields? If so, your data structure is wrong.
    >
    > Please give a real example. What are the names of the fields and what is
    > the user typing in one of them?
    >
    > --
    > Rick B
    >
    >
    >
    > "an" <an@discussions.microsoft.com> wrote in message
    > news:7598C2F9-5306-44CE-ADA5-06869A59026F@microsoft.com...
    > > Thanks for your reply.
    > >
    > > My idea is:
    > > 1 - Each button to run the query filled with option x/20, writed in
    > > clicked
    > > cmd.
    > > But only one form, based in selected query trought button clicked.
    > >
    > > Or
    > >
    > > 2 - With 20 queries and each button to run distinct query but only one
    > > form
    > > based on choosed selected trought respective button.
    > >
    > > an
    > >
    > > "Rick B" wrote:
    > >
    > >> Please explain exactly what these "20 options" are. Building a form with
    > >> 20
    > >> buttons (each of which will open the same query, but with a different
    > >> option) does not seem like a very good way to have a user run a query.
    > >>
    > >>
    > >>
    > >> --
    > >> Rick B
    > >>
    > >>
    > >>
    > >> "an" <an@discussions.microsoft.com> wrote in message
    > >> news:93FB5792-9AC2-4E27-8B7C-8A81B5CF6E31@microsoft.com...
    > >> > Hi!
    > >> > I have one form based in query that asks for the option, in a set of 20
    > >> > options that are fixed.
    > >> >
    > >> > I would like, instead of having to write the option, to open one
    > >> > auxiliar
    > >> > form with command buttons each one with one of these 20 options, and
    > >> > with
    > >> > click in one of the buttons, to make to run this query for form to
    > >> > assist
    > >> > and
    > >> > open it.
    > >> >
    > >> > Is it possible?
    > >> >
    > >> > Thanks in advance.
    > >> > an
    > >>
    > >>
    > >>

    >
    >
    >
     
  8. Rick B

    Rick B
    Expand Collapse
    Guest

    Personally, I would continue to prompt the user for the desired month. I
    would not think a screen with a bunch of buttons would be an easier user
    interface. A form with a drop-down from which the month could be selected
    might be ok.

    --
    Rick B



    "an" <an@discussions.microsoft.com> wrote in message
    news:B6DB3142-07CF-49F2-9E8D-AC8D2E443380@microsoft.com...
    > Sorry.
    >
    > For example:
    >
    > I have 12 months.
    > The query ask me [what the month?]
    > I write: JANUARY or FEBRUARY or another to DECEMBER (n/12)
    > I would like to click on respective button (in auxiliar form) to fill the
    > query, to run it, and to open ONE form based in this "conditional" query.
    >
    > I don't know if is possible...
    >
    > an
    >
    > "Rick B" wrote:
    >
    >> I still don't understand. What does, "run the query filled with option
    >> x/20" mean?
    >>
    >> Do you have 20 fields that all contain the same type of data, and you
    >> don't
    >> know which field it will be in? In other words, could a value appear in
    >> any
    >> one of the 20 fields? If so, your data structure is wrong.
    >>
    >> Please give a real example. What are the names of the fields and what is
    >> the user typing in one of them?
    >>
    >> --
    >> Rick B
    >>
    >>
    >>
    >> "an" <an@discussions.microsoft.com> wrote in message
    >> news:7598C2F9-5306-44CE-ADA5-06869A59026F@microsoft.com...
    >> > Thanks for your reply.
    >> >
    >> > My idea is:
    >> > 1 - Each button to run the query filled with option x/20, writed in
    >> > clicked
    >> > cmd.
    >> > But only one form, based in selected query trought button clicked.
    >> >
    >> > Or
    >> >
    >> > 2 - With 20 queries and each button to run distinct query but only one
    >> > form
    >> > based on choosed selected trought respective button.
    >> >
    >> > an
    >> >
    >> > "Rick B" wrote:
    >> >
    >> >> Please explain exactly what these "20 options" are. Building a form
    >> >> with
    >> >> 20
    >> >> buttons (each of which will open the same query, but with a different
    >> >> option) does not seem like a very good way to have a user run a query.
    >> >>
    >> >>
    >> >>
    >> >> --
    >> >> Rick B
    >> >>
    >> >>
    >> >>
    >> >> "an" <an@discussions.microsoft.com> wrote in message
    >> >> news:93FB5792-9AC2-4E27-8B7C-8A81B5CF6E31@microsoft.com...
    >> >> > Hi!
    >> >> > I have one form based in query that asks for the option, in a set of
    >> >> > 20
    >> >> > options that are fixed.
    >> >> >
    >> >> > I would like, instead of having to write the option, to open one
    >> >> > auxiliar
    >> >> > form with command buttons each one with one of these 20 options, and
    >> >> > with
    >> >> > click in one of the buttons, to make to run this query for form to
    >> >> > assist
    >> >> > and
    >> >> > open it.
    >> >> >
    >> >> > Is it possible?
    >> >> >
    >> >> > Thanks in advance.
    >> >> > an
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  9. an

    an
    Expand Collapse
    Guest

    But I will have to have one query for each different result, certain?
    Until here, ok.
    But I will continue to need others as much forms, no?.
    It was this that would like to prevent...

    Thanks.
    an

    "Rick B" wrote:

    > Personally, I would continue to prompt the user for the desired month. I
    > would not think a screen with a bunch of buttons would be an easier user
    > interface. A form with a drop-down from which the month could be selected
    > might be ok.
    >
    > --
    > Rick B
    >
    >
    >
    > "an" <an@discussions.microsoft.com> wrote in message
    > news:B6DB3142-07CF-49F2-9E8D-AC8D2E443380@microsoft.com...
    > > Sorry.
    > >
    > > For example:
    > >
    > > I have 12 months.
    > > The query ask me [what the month?]
    > > I write: JANUARY or FEBRUARY or another to DECEMBER (n/12)
    > > I would like to click on respective button (in auxiliar form) to fill the
    > > query, to run it, and to open ONE form based in this "conditional" query.
    > >
    > > I don't know if is possible...
    > >
    > > an
    > >
    > > "Rick B" wrote:
    > >
    > >> I still don't understand. What does, "run the query filled with option
    > >> x/20" mean?
    > >>
    > >> Do you have 20 fields that all contain the same type of data, and you
    > >> don't
    > >> know which field it will be in? In other words, could a value appear in
    > >> any
    > >> one of the 20 fields? If so, your data structure is wrong.
    > >>
    > >> Please give a real example. What are the names of the fields and what is
    > >> the user typing in one of them?
    > >>
    > >> --
    > >> Rick B
    > >>
    > >>
    > >>
    > >> "an" <an@discussions.microsoft.com> wrote in message
    > >> news:7598C2F9-5306-44CE-ADA5-06869A59026F@microsoft.com...
    > >> > Thanks for your reply.
    > >> >
    > >> > My idea is:
    > >> > 1 - Each button to run the query filled with option x/20, writed in
    > >> > clicked
    > >> > cmd.
    > >> > But only one form, based in selected query trought button clicked.
    > >> >
    > >> > Or
    > >> >
    > >> > 2 - With 20 queries and each button to run distinct query but only one
    > >> > form
    > >> > based on choosed selected trought respective button.
    > >> >
    > >> > an
    > >> >
    > >> > "Rick B" wrote:
    > >> >
    > >> >> Please explain exactly what these "20 options" are. Building a form
    > >> >> with
    > >> >> 20
    > >> >> buttons (each of which will open the same query, but with a different
    > >> >> option) does not seem like a very good way to have a user run a query.
    > >> >>
    > >> >>
    > >> >>
    > >> >> --
    > >> >> Rick B
    > >> >>
    > >> >>
    > >> >>
    > >> >> "an" <an@discussions.microsoft.com> wrote in message
    > >> >> news:93FB5792-9AC2-4E27-8B7C-8A81B5CF6E31@microsoft.com...
    > >> >> > Hi!
    > >> >> > I have one form based in query that asks for the option, in a set of
    > >> >> > 20
    > >> >> > options that are fixed.
    > >> >> >
    > >> >> > I would like, instead of having to write the option, to open one
    > >> >> > auxiliar
    > >> >> > form with command buttons each one with one of these 20 options, and
    > >> >> > with
    > >> >> > click in one of the buttons, to make to run this query for form to
    > >> >> > assist
    > >> >> > and
    > >> >> > open it.
    > >> >> >
    > >> >> > Is it possible?
    > >> >> >
    > >> >> > Thanks in advance.
    > >> >> > an
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  10. Rick B

    Rick B
    Expand Collapse
    Guest

    I don't know what that means.

    No, you would not need more than one query.

    You can limit the data displayed based on the input.

    You have a bunch of records. You only want to pull records where the data
    contains "December". You can do so by pulling out the month portion of the
    date and only selecting records that are from December.

    Unless you spell out for us the structure of your table and show us an
    example of your records, I don't think you will get a better answer. I have
    asked you to explain exactly what the data looks like and what you are
    trying to accomplish. You have not done that. What are the fields in your
    table? When the user enters the month, what happens to that? You have
    never really explained why you have 20 different queries (if that is what
    you are saying).

    We can't see your database. We can't see your query. all I am saying is
    that I have never had to build twenty (almost) identical queries to pull
    the same type of data. I've also never had to build a form using buttons to
    help the user select data to pull to a query. For example, If I have a
    query that will pull one particular person's records, then I ask the user to
    tell me which person. I'd not want a separate button for each userid. It
    would be too busy and I'd spend all my time updating it every time a new
    employee started or left. In your example, are you going to have to add a
    button to your form every month? If so, it would be a nightmare.

    Please give us the details we need to understand exactly what you are doing,
    why it is not working well for you, and what you'd like to change to make it
    easier. Include an example of the data being pulled. What does a record
    look like? How do I specify which records to pull? Etc.

    details, details, details, please.

    --
    Rick B



    "an" <an@discussions.microsoft.com> wrote in message
    news:3E93BEC5-2CD9-42A3-BFDE-32EBEC877E47@microsoft.com...
    > But I will have to have one query for each different result, certain?
    > Until here, ok.
    > But I will continue to need others as much forms, no?.
    > It was this that would like to prevent...
    >
    > Thanks.
    > an
    >
    > "Rick B" wrote:
    >
    >> Personally, I would continue to prompt the user for the desired month. I
    >> would not think a screen with a bunch of buttons would be an easier user
    >> interface. A form with a drop-down from which the month could be
    >> selected
    >> might be ok.
    >>
    >> --
    >> Rick B
    >>
    >>
    >>
    >> "an" <an@discussions.microsoft.com> wrote in message
    >> news:B6DB3142-07CF-49F2-9E8D-AC8D2E443380@microsoft.com...
    >> > Sorry.
    >> >
    >> > For example:
    >> >
    >> > I have 12 months.
    >> > The query ask me [what the month?]
    >> > I write: JANUARY or FEBRUARY or another to DECEMBER (n/12)
    >> > I would like to click on respective button (in auxiliar form) to fill
    >> > the
    >> > query, to run it, and to open ONE form based in this "conditional"
    >> > query.
    >> >
    >> > I don't know if is possible...
    >> >
    >> > an
    >> >
    >> > "Rick B" wrote:
    >> >
    >> >> I still don't understand. What does, "run the query filled with
    >> >> option
    >> >> x/20" mean?
    >> >>
    >> >> Do you have 20 fields that all contain the same type of data, and you
    >> >> don't
    >> >> know which field it will be in? In other words, could a value appear
    >> >> in
    >> >> any
    >> >> one of the 20 fields? If so, your data structure is wrong.
    >> >>
    >> >> Please give a real example. What are the names of the fields and what
    >> >> is
    >> >> the user typing in one of them?
    >> >>
    >> >> --
    >> >> Rick B
    >> >>
    >> >>
    >> >>
    >> >> "an" <an@discussions.microsoft.com> wrote in message
    >> >> news:7598C2F9-5306-44CE-ADA5-06869A59026F@microsoft.com...
    >> >> > Thanks for your reply.
    >> >> >
    >> >> > My idea is:
    >> >> > 1 - Each button to run the query filled with option x/20, writed in
    >> >> > clicked
    >> >> > cmd.
    >> >> > But only one form, based in selected query trought button clicked.
    >> >> >
    >> >> > Or
    >> >> >
    >> >> > 2 - With 20 queries and each button to run distinct query but only
    >> >> > one
    >> >> > form
    >> >> > based on choosed selected trought respective button.
    >> >> >
    >> >> > an
    >> >> >
    >> >> > "Rick B" wrote:
    >> >> >
    >> >> >> Please explain exactly what these "20 options" are. Building a
    >> >> >> form
    >> >> >> with
    >> >> >> 20
    >> >> >> buttons (each of which will open the same query, but with a
    >> >> >> different
    >> >> >> option) does not seem like a very good way to have a user run a
    >> >> >> query.
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >> --
    >> >> >> Rick B
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >> "an" <an@discussions.microsoft.com> wrote in message
    >> >> >> news:93FB5792-9AC2-4E27-8B7C-8A81B5CF6E31@microsoft.com...
    >> >> >> > Hi!
    >> >> >> > I have one form based in query that asks for the option, in a set
    >> >> >> > of
    >> >> >> > 20
    >> >> >> > options that are fixed.
    >> >> >> >
    >> >> >> > I would like, instead of having to write the option, to open one
    >> >> >> > auxiliar
    >> >> >> > form with command buttons each one with one of these 20 options,
    >> >> >> > and
    >> >> >> > with
    >> >> >> > click in one of the buttons, to make to run this query for form
    >> >> >> > to
    >> >> >> > assist
    >> >> >> > and
    >> >> >> > open it.
    >> >> >> >
    >> >> >> > Is it possible?
    >> >> >> >
    >> >> >> > Thanks in advance.
    >> >> >> > an
    >> >> >>
    >> >> >>
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  11. an

    an
    Expand Collapse
    Guest

    R B,

    Basically what I needed to know is if there are some way to substitute the
    writing of the "n" hypotheses asked for query, for another automatic way,
    showing these possibilities, to click in one of them and the query to assume
    this string.

    But... your very pertinents questions, they suggest that perhaps it has to
    rethink in reorganizes of the database.

    Gratefull for your help.
    an

    "Rick B" wrote:

    > I don't know what that means.
    >
    > No, you would not need more than one query.
    >
    > You can limit the data displayed based on the input.
    >
    > You have a bunch of records. You only want to pull records where the data
    > contains "December". You can do so by pulling out the month portion of the
    > date and only selecting records that are from December.
    >
    > Unless you spell out for us the structure of your table and show us an
    > example of your records, I don't think you will get a better answer. I have
    > asked you to explain exactly what the data looks like and what you are
    > trying to accomplish. You have not done that. What are the fields in your
    > table? When the user enters the month, what happens to that? You have
    > never really explained why you have 20 different queries (if that is what
    > you are saying).
    >
    > We can't see your database. We can't see your query. all I am saying is
    > that I have never had to build twenty (almost) identical queries to pull
    > the same type of data. I've also never had to build a form using buttons to
    > help the user select data to pull to a query. For example, If I have a
    > query that will pull one particular person's records, then I ask the user to
    > tell me which person. I'd not want a separate button for each userid. It
    > would be too busy and I'd spend all my time updating it every time a new
    > employee started or left. In your example, are you going to have to add a
    > button to your form every month? If so, it would be a nightmare.
    >
    > Please give us the details we need to understand exactly what you are doing,
    > why it is not working well for you, and what you'd like to change to make it
    > easier. Include an example of the data being pulled. What does a record
    > look like? How do I specify which records to pull? Etc.
    >
    > details, details, details, please.
    >
    > --
    > Rick B
    >
    >
    >
    > "an" <an@discussions.microsoft.com> wrote in message
    > news:3E93BEC5-2CD9-42A3-BFDE-32EBEC877E47@microsoft.com...
    > > But I will have to have one query for each different result, certain?
    > > Until here, ok.
    > > But I will continue to need others as much forms, no?.
    > > It was this that would like to prevent...
    > >
    > > Thanks.
    > > an
    > >
    > > "Rick B" wrote:
    > >
    > >> Personally, I would continue to prompt the user for the desired month. I
    > >> would not think a screen with a bunch of buttons would be an easier user
    > >> interface. A form with a drop-down from which the month could be
    > >> selected
    > >> might be ok.
    > >>
    > >> --
    > >> Rick B
    > >>
    > >>
    > >>
    > >> "an" <an@discussions.microsoft.com> wrote in message
    > >> news:B6DB3142-07CF-49F2-9E8D-AC8D2E443380@microsoft.com...
    > >> > Sorry.
    > >> >
    > >> > For example:
    > >> >
    > >> > I have 12 months.
    > >> > The query ask me [what the month?]
    > >> > I write: JANUARY or FEBRUARY or another to DECEMBER (n/12)
    > >> > I would like to click on respective button (in auxiliar form) to fill
    > >> > the
    > >> > query, to run it, and to open ONE form based in this "conditional"
    > >> > query.
    > >> >
    > >> > I don't know if is possible...
    > >> >
    > >> > an
    > >> >
    > >> > "Rick B" wrote:
    > >> >
    > >> >> I still don't understand. What does, "run the query filled with
    > >> >> option
    > >> >> x/20" mean?
    > >> >>
    > >> >> Do you have 20 fields that all contain the same type of data, and you
    > >> >> don't
    > >> >> know which field it will be in? In other words, could a value appear
    > >> >> in
    > >> >> any
    > >> >> one of the 20 fields? If so, your data structure is wrong.
    > >> >>
    > >> >> Please give a real example. What are the names of the fields and what
    > >> >> is
    > >> >> the user typing in one of them?
    > >> >>
    > >> >> --
    > >> >> Rick B
    > >> >>
    > >> >>
    > >> >>
    > >> >> "an" <an@discussions.microsoft.com> wrote in message
    > >> >> news:7598C2F9-5306-44CE-ADA5-06869A59026F@microsoft.com...
    > >> >> > Thanks for your reply.
    > >> >> >
    > >> >> > My idea is:
    > >> >> > 1 - Each button to run the query filled with option x/20, writed in
    > >> >> > clicked
    > >> >> > cmd.
    > >> >> > But only one form, based in selected query trought button clicked.
    > >> >> >
    > >> >> > Or
    > >> >> >
    > >> >> > 2 - With 20 queries and each button to run distinct query but only
    > >> >> > one
    > >> >> > form
    > >> >> > based on choosed selected trought respective button.
    > >> >> >
    > >> >> > an
    > >> >> >
    > >> >> > "Rick B" wrote:
    > >> >> >
    > >> >> >> Please explain exactly what these "20 options" are. Building a
    > >> >> >> form
    > >> >> >> with
    > >> >> >> 20
    > >> >> >> buttons (each of which will open the same query, but with a
    > >> >> >> different
    > >> >> >> option) does not seem like a very good way to have a user run a
    > >> >> >> query.
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >> >> --
    > >> >> >> Rick B
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >> >> "an" <an@discussions.microsoft.com> wrote in message
    > >> >> >> news:93FB5792-9AC2-4E27-8B7C-8A81B5CF6E31@microsoft.com...
    > >> >> >> > Hi!
    > >> >> >> > I have one form based in query that asks for the option, in a set
    > >> >> >> > of
    > >> >> >> > 20
    > >> >> >> > options that are fixed.
    > >> >> >> >
    > >> >> >> > I would like, instead of having to write the option, to open one
    > >> >> >> > auxiliar
    > >> >> >> > form with command buttons each one with one of these 20 options,
    > >> >> >> > and
    > >> >> >> > with
    > >> >> >> > click in one of the buttons, to make to run this query for form
    > >> >> >> > to
    > >> >> >> > assist
    > >> >> >> > and
    > >> >> >> > open it.
    > >> >> >> >
    > >> >> >> > Is it possible?
    > >> >> >> >
    > >> >> >> > Thanks in advance.
    > >> >> >> > an
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     

Share This Page