Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2005
    New England

    Unanswered: I need some help from the pros...or anyone more knowledgeable than me (aka everyone)

    Hi all, I could really use some help from those more expert than I. I work with children on a behavioral unit, and we have a form that we use to track behaviors. There can be anywhere from 1-21 targets for each child, and then a need for 15 additional fields to track the scores (twice daily) and the current baseline.The issue is that the tables apparently can't hold more than 144 fields and I have a need for the ability to have a maximum of 338 fields. I currently have 2 tables, however this is also proving to be a bit problematic. Can anyone suggest anything better....or does anyone know if there IS anything to be done about this. Also, why do they have a limit on table size, and why 144? Grr...
    Last edited by RAPUNIT; 09-29-05 at 15:24.

  2. #2
    Join Date
    Sep 2003
    Access has a limit of 255 columns ... Traditionally, you'd create a table for your targets keyed to each child (childID perhaps?) allowing for the flexibility to have varying # of targets ... you can do the same for the scores by tying to the child AND Date AND session (1st or 2nd) ... Basically, what I've said is that you need to design your database appropriately.
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 9
    Why not Go down


    ChildID is link to the Child table
    Sdate has a default value of Now()
    Score is the score Value

    Then desgin a Form with a ubound combo box List the Children

    then Create a Sub form and Bound (link master/child Form) to that combo box
    combobox to childID Know when the the combo box is change to Child form(link form )

    when the combo changes the subform will change to match the combo box
    Last edited by myle; 09-29-05 at 16:17.
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  4. #4
    Join Date
    Aug 2005
    New England

    Currently I do the following...

    MedicalRecordNumber, AdmissionNumber (linked to Child's Demographics)
    TargetOneTuePM.....repeating until SundayPM
    TargetTwoMonPM.....I'm thinking you've got the point.

    I need to be able to track the scores for each target twice per day, for one full week Mon-Sun. M.Owen, what would be a better way to design the table structures? I genuinely appreciate the help.

  5. #5
    Join Date
    Apr 2004
    outside the rim
    Three tables:
    1. child info
    2. behaviors tracked by child
    3. results of behaviors for each child

    Diagram attached.

    Entering results on a daily basis:
    For the main form, make a totals query that groups by child name then date/time of results. Have a combo with the child's names on this form. Select a child's name and the form filters to show the date/times there is information.
    Make a subform that is based on the child's name and the date/time on the main form and shows the behaviors and the reults
    Put a command button that allows you to enter a new set of records (a new date/time value) that copies the set of behaviors from a "base table" to the results table.

    Setting up the behaviors for each child
    A simple data entry form in which you select a child and enter each behavior you want to track.

    This allows you 1 to Many behaviors that you can track for each child over time.

    For the reports, simply group by the child, then the date/time, to display results over time.

    There are about 500 ways to take what I suggested above and make it better - this is a detailed concept that defines a direction you could go in.

    Good luck
    Attached Thumbnails Attached Thumbnails example.JPG  
    have fun!

    Todd S.
    click to email

    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET

    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts