Welcome to SPN

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

Sign Up Now!

List Boxes

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

Tags:
  1. BrianH

    BrianH
    Expand Collapse
    Guest

    Bare with me but I am fairly new to Access. I have a database with
    approximately 40 tables. All of the tables are grouped in threes. I
    am trying to to create a form in which I can have a list box/boxes,
    that will allow me to chose which table and then which field in that
    table. I need to run variances of these values that I pick and I would
    create the query from there. Basically, I need a blank form like the
    one when you start up the form wizard. You can pick what tables and
    what fields you want in this wizard and I am trying to create this for
    my database.

    Thanks so much for your help in advance.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News How The Left & Indian Nationalists Distorted The History Of Sikh Gadhar Movement - Breaking News Sep 21, 2016
    Interfaith Materialists And Its Discontents Interfaith Dialogues Jun 10, 2016
    Sikhi Quasi-Pragmatists And Quasi-Spiritualists, Care To Explain? Sikh Sikhi Sikhism Jun 6, 2016
    Cholesterol Is Finally Officially Removed From "naughty List" Health & Nutrition Feb 11, 2016
    Listening to Gurbani while driving?? Sikh Rehat Maryada Jan 13, 2016

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    It sounds like your database structure is not normalized. Seems like these
    multiple tables should be one with a field to signify the difference you now
    use separate tables to segregate the data.
    Give some more information about what you have in these tables. Some
    examples of the data. How you plan to use the data.

    "BrianH" wrote:

    > Bare with me but I am fairly new to Access. I have a database with
    > approximately 40 tables. All of the tables are grouped in threes. I
    > am trying to to create a form in which I can have a list box/boxes,
    > that will allow me to chose which table and then which field in that
    > table. I need to run variances of these values that I pick and I would
    > create the query from there. Basically, I need a blank form like the
    > one when you start up the form wizard. You can pick what tables and
    > what fields you want in this wizard and I am trying to create this for
    > my database.
    >
    > Thanks so much for your help in advance.
    >
    >
     
  4. BrianH

    BrianH
    Expand Collapse
    Guest

    Wellll...I got the creation of the List Box that I wanted. The form
    has a list box that has all o fht etables in my database which is
    great. However, I need to be able to click that table in the list box
    and in another list box have the field show up. I would Potentially
    like to have that second list box pick and chose which fields I want
    from whatever tables I have in the first list box. Does this make
    sense? I think it is like the form wizard where you can move field that
    you need over to another box.


    I hope this wasn't too confusing. Thanks!!



    KARL DEWEY wrote:
    > It sounds like your database structure is not normalized. Seems like these
    > multiple tables should be one with a field to signify the difference you now
    > use separate tables to segregate the data.
    > Give some more information about what you have in these tables. Some
    > examples of the data. How you plan to use the data.
    >
     
  5. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Search on Cascading ComboBoxes

    "BrianH" wrote:

    > Wellll...I got the creation of the List Box that I wanted. The form
    > has a list box that has all o fht etables in my database which is
    > great. However, I need to be able to click that table in the list box
    > and in another list box have the field show up. I would Potentially
    > like to have that second list box pick and chose which fields I want
    > from whatever tables I have in the first list box. Does this make
    > sense? I think it is like the form wizard where you can move field that
    > you need over to another box.
    >
    >
    > I hope this wasn't too confusing. Thanks!!
    >
    >
    >
    > KARL DEWEY wrote:
    > > It sounds like your database structure is not normalized. Seems like these
    > > multiple tables should be one with a field to signify the difference you now
    > > use separate tables to segregate the data.
    > > Give some more information about what you have in these tables. Some
    > > examples of the data. How you plan to use the data.
    > >

    >
    >
     

Share This Page