Welcome to SPN

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

Sign Up Now!

Trouble with subdatasheet

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

  1. mhutch71

    mhutch71
    Expand Collapse
    Guest

    I am trying to get Access to show a list of employees with a subdatasheet
    under each name showing their QA scores but can not seen to get it right. I
    have data on every employee broken down by months showing the employees QA
    score in Excel. There is about 7 catagories that each employee is grded on
    each month. I can get the data from Excel to Access with no problem but can
    not get it to display the way that I want it. I would like to open a list of
    each employee and under their name have the QA scores listed by month so the
    supervisors and employees can see how they are doing. I am going to add more
    data to the display later but right now just can not get the information to
    display. I ahve tried forms and queries but can not get all the data to
    display. Is there a way to display all the data for the employee?
     
  2. Loading...

    Similar Threads Forum Date
    World Toilet Trouble: New Technology and Infrastructures with Dr. Doulaye Kone Breaking News Oct 26, 2013
    USA El Sobrante Gurdwara Committee Troubles Continue Breaking News Jun 25, 2013
    India Troubled Reminder - A memorial for Op Bluestar ‘martyrs’? Breaking News May 12, 2012
    Trouble Understanding This Pauree of Bhai Gurdas Sikh Sikhi Sikhism Sep 5, 2011
    Hinduism Film Screening to Foster Ethnic Unity Stirs Trouble Instead Interfaith Dialogues Jul 22, 2011

  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    First, it sounds like you're working directly in the table. Don't. Access
    tables are "buckets 'o data". Access forms (and reports) are used to
    display data.

    I don't have a clear picture of your underlying data structure. Since how
    you'd display data depends on how it's organized, consider posting a brief
    description of your table structure.

    If you want a way to select an employee from a list and see that employee's
    QA scores, consider creating an unbound form. Add a combo box in which you
    select the employee. Add a listbox based on a query that uses the combo box
    as a criterion for which employee. Do whatever aggregation and sorting you
    need to in that query that you use to feed your listbox.

    Then, in the "Select employee" combo box's AfterUpdate event, add in code to
    requery the listbox -- something like:

    Me.lstYourListBox.Requey

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP


    "mhutch71" <mhutch71@discussions.microsoft.com> wrote in message
    news:02E3E8BA-53F8-49A8-A841-51C142C00270@microsoft.com...
    >I am trying to get Access to show a list of employees with a subdatasheet
    > under each name showing their QA scores but can not seen to get it right.
    > I
    > have data on every employee broken down by months showing the employees QA
    > score in Excel. There is about 7 catagories that each employee is grded on
    > each month. I can get the data from Excel to Access with no problem but
    > can
    > not get it to display the way that I want it. I would like to open a list
    > of
    > each employee and under their name have the QA scores listed by month so
    > the
    > supervisors and employees can see how they are doing. I am going to add
    > more
    > data to the display later but right now just can not get the information
    > to
    > display. I ahve tried forms and queries but can not get all the data to
    > display. Is there a way to display all the data for the employee?
     

Share This Page