Welcome to SPN

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

Sign Up Now!

im stuck! ah help!

Discussion in 'Information Technology' started by Kyle.H.Green@gmail.com, Jul 28, 2006.

Tags:
  1. Kyle.H.Green@gmail.com

    Kyle.H.Green@gmail.com
    Expand Collapse
    Guest

    Hello everyone and thankyou for taking your time to read this. I
    apologize for posting in multiple groups (for some of you have noticed)
    but I need maximum feedback. Here's the nitty gritty.

    The database is for BF Goodrich (Michelin's company). This could be
    distributed worldwide, so if you have a direct helping hand in it, I
    will have no problem with putting names and contact details in the
    information somewhere.

    Lets start with the table. Here's a snapshot of what it looks like.

    http://i16.photobucket.com/albums/b17/bamabmw/Michelin/table.jpg

    What is being stored is information about engineering schematics. Large
    G sized drawings that are about 3 feet tall and 4 feet wide. The table
    holds all details including a link to the file on the network.

    The form I've constructed looks like this.

    http://i16.photobucket.com/albums/b17/bamabmw/Michelin/template.jpg

    =================================================================
    FIRST AREA OF TROUBLE
    =================================================================

    If you'll notice I labed 4 fields as filters. I would like these to be
    dropdown boxes. PROJECT, PRIMARY, SECONDARY, and DISCIPLINE, while
    holding 22,000 values, are of a limited variety. Project for example
    has Group9, Group7, VMI, Electrical, but over and over.

    I would like the first filter (DROPDOWN) to only show a list of all
    possible ones, and then that filtered list is passed on to the 2nd,
    then to the 3rd, and finally to the 4th.

    At this point I think a LISTBOX could be overlayed ontop of the NOTE2
    area so that the filtered drawings could be selected (which will update
    the preview image placeholder on the right).

    =================================================================
    SECOND AREA OF TROUBLE
    =================================================================

    Examine note 3. I put this search field here because this program is
    supposed to make life easier for a whole load of engineers, however I
    have been unable to get the following results.

    1 > user enters keyword(s) in formbased search field
    2 > all fields in the table are searched. ALL of them, for any and all
    occurences
    3 > listbox (organized by the drawing numbers @ note1) appears for them
    to select from, updating preview on right side




    -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

    I'm not a professional coder, and my Access experience is limited. Not
    the ideal situation for replacing old software
    (http://i16.photobucket.com/albums/b17/bamabmw/Michelin/workflowsnapshot.jpg)
    but it's something that must be done.

    My email is visible to you but thanks to ISIS, IBM and Michelin
    internet security standards and practices, I'm unable to access gmail
    from work (my replies could be slow.)

    If you think you can directly help me over the phone, please feel free
    to contact me (Kyle) at the following work number. Our automated
    attendant is reachable at 1-205-752-1529 extension 433 (dial anytime
    after the female voice begins talking). Thankyou everyone for posts,
    emails, and calls. You don't know how much I appreciate it.

    ~ Kyle Green
     
  2. Loading...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    PLEASE refrain from posting your question in multiple groups.

    Netiquette FAQ
    http://www.mvps.org/access/netiquette.htm


    --
    Rick B



    <Kyle.H.Green@gmail.com> wrote in message
    news:1148329485.128467.121930@j73g2000cwa.googlegroups.com...
    > Hello everyone and thankyou for taking your time to read this. I
    > apologize for posting in multiple groups (for some of you have noticed)
    > but I need maximum feedback. Here's the nitty gritty.
    >
    > The database is for BF Goodrich (Michelin's company). This could be
    > distributed worldwide, so if you have a direct helping hand in it, I
    > will have no problem with putting names and contact details in the
    > information somewhere.
    >
    > Lets start with the table. Here's a snapshot of what it looks like.
    >
    > http://i16.photobucket.com/albums/b17/bamabmw/Michelin/table.jpg
    >
    > What is being stored is information about engineering schematics. Large
    > G sized drawings that are about 3 feet tall and 4 feet wide. The table
    > holds all details including a link to the file on the network.
    >
    > The form I've constructed looks like this.
    >
    > http://i16.photobucket.com/albums/b17/bamabmw/Michelin/template.jpg
    >
    > =================================================================
    > FIRST AREA OF TROUBLE
    > =================================================================
    >
    > If you'll notice I labed 4 fields as filters. I would like these to be
    > dropdown boxes. PROJECT, PRIMARY, SECONDARY, and DISCIPLINE, while
    > holding 22,000 values, are of a limited variety. Project for example
    > has Group9, Group7, VMI, Electrical, but over and over.
    >
    > I would like the first filter (DROPDOWN) to only show a list of all
    > possible ones, and then that filtered list is passed on to the 2nd,
    > then to the 3rd, and finally to the 4th.
    >
    > At this point I think a LISTBOX could be overlayed ontop of the NOTE2
    > area so that the filtered drawings could be selected (which will update
    > the preview image placeholder on the right).
    >
    > =================================================================
    > SECOND AREA OF TROUBLE
    > =================================================================
    >
    > Examine note 3. I put this search field here because this program is
    > supposed to make life easier for a whole load of engineers, however I
    > have been unable to get the following results.
    >
    > 1 > user enters keyword(s) in formbased search field
    > 2 > all fields in the table are searched. ALL of them, for any and all
    > occurences
    > 3 > listbox (organized by the drawing numbers @ note1) appears for them
    > to select from, updating preview on right side
    >
    >
    >
    >
    > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
    >
    > I'm not a professional coder, and my Access experience is limited. Not
    > the ideal situation for replacing old software
    > (http://i16.photobucket.com/albums/b17/bamabmw/Michelin/workflowsnapshot.jpg)
    > but it's something that must be done.
    >
    > My email is visible to you but thanks to ISIS, IBM and Michelin
    > internet security standards and practices, I'm unable to access gmail
    > from work (my replies could be slow.)
    >
    > If you think you can directly help me over the phone, please feel free
    > to contact me (Kyle) at the following work number. Our automated
    > attendant is reachable at 1-205-752-1529 extension 433 (dial anytime
    > after the female voice begins talking). Thankyou everyone for posts,
    > emails, and calls. You don't know how much I appreciate it.
    >
    > ~ Kyle Green
    >
     
  4. Robin

    Robin
    Expand Collapse
    Guest

    With 22,000 repeating values in just one field, I think you may need to
    seriously re-think your database design before you even think about these
    filters. I've just been through the same learning process and I'd recommend
    that you understand Database Normalization first, particularly with regard
    to data redundancy - and at least to 3NF. Try looking at:

    http://www.datamodel.org/NormalizationRules.html

    Still, you'll probably get lots of helpful phone calls and emails anyway.

    <Kyle.H.Green@gmail.com> wrote in message
    news:1148329485.128467.121930@j73g2000cwa.googlegroups.com...
    > Hello everyone and thankyou for taking your time to read this.
     

Share This Page