Welcome to SPN

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

Sign Up Now!

Creating a search form with checkboxes

Discussion in 'Information Technology' started by laurapizzolo@gmail.com, Jul 28, 2006.

  1. laurapizzolo@gmail.com

    laurapizzolo@gmail.com
    Expand Collapse
    Guest

    Hi,

    This sounds painfully easy and I'm sure everyone will skip it, but for
    some reason I have a little problem that's so evidently solved by
    everyone (but me) that i can't find any decent answer or help in the
    reference books etc...

    I'm preparing a search form for a data base i'm miraculously supposed
    to pull together with no training or skills (self-taught suddenly
    sounds ambitious, cause I don't remember learning much even though I
    was all by myself). What I need to do is search a wide variety of
    information (word documents and pdf files) that is already separated
    into different folders. So, basically, I need to search a table that
    lists all the different folders.

    I have 4 critieria to do this:
    Country
    Consultant
    Name
    Action

    knowing that Action is really a header for 5 different possibilities:
    garbage, transport, energy, nature and other.

    My masterplan would have been to create a form with drop boxes for the
    first 3 (country, consultatn and name) and then an object of 5 check
    boxes for the 4th criteria.

    Which I did

    But, somehow, i can only check one at a time....???? was i supposed to
    do something special? (other than be sure that the field is set for
    numerical info)

    also, how do i enter information in the database table?


    thanks abundantly,

    lkaura
     
  2. Loading...

    Similar Threads Forum Date
    Canada Ottawa weighs creating ambassador for religious freedom Breaking News Oct 4, 2011
    India SGPC Accused of Creating a Row Breaking News Jan 20, 2011
    Pacific International Gathering of Young Sikhs Focuses on Creating Good Citizens Breaking News Jan 8, 2011
    Are We Creating New Devtas? Sikh Sikhi Sikhism Aug 21, 2009
    Sikh News Sharif warns against creating instability in Punjab (Express India) Breaking News Sep 19, 2008

  3. microb0x

    microb0x
    Expand Collapse
    Guest

    How did you create the checkboxes on your form? Were they created
    using an Option Group? You would need to create each checkbox
    separately I believe. Creating them with an option group is creating a
    scenerio that is like: (check1 or check2 or check3, etc.) which it
    sounds like this is NOT what you want. You want to be able to select
    multiple, so just use the Checkbox option from the toolbox instead of
    option group.

    More info is needed to help with populating your table(s). How would
    you like to accomplish this? Through entry on a form? With VBA code?
    With a macro? Manually typing directly into the table?


    laurapizzolo@gmail.com wrote:
    > Hi,
    >
    > This sounds painfully easy and I'm sure everyone will skip it, but for
    > some reason I have a little problem that's so evidently solved by
    > everyone (but me) that i can't find any decent answer or help in the
    > reference books etc...
    >
    > I'm preparing a search form for a data base i'm miraculously supposed
    > to pull together with no training or skills (self-taught suddenly
    > sounds ambitious, cause I don't remember learning much even though I
    > was all by myself). What I need to do is search a wide variety of
    > information (word documents and pdf files) that is already separated
    > into different folders. So, basically, I need to search a table that
    > lists all the different folders.
    >
    > I have 4 critieria to do this:
    > Country
    > Consultant
    > Name
    > Action
    >
    > knowing that Action is really a header for 5 different possibilities:
    > garbage, transport, energy, nature and other.
    >
    > My masterplan would have been to create a form with drop boxes for the
    > first 3 (country, consultatn and name) and then an object of 5 check
    > boxes for the 4th criteria.
    >
    > Which I did
    >
    > But, somehow, i can only check one at a time....???? was i supposed to
    > do something special? (other than be sure that the field is set for
    > numerical info)
    >
    > also, how do i enter information in the database table?
    >
    >
    > thanks abundantly,
    >
    > lkaura
     

Share This Page