Page 7 of 7 FirstFirst 1234567
Results 91 to 104 of 104
  1. #91
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393

    the maximum number of questions on a check-list at the moment is about 130

  2. #92
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    I think you misunderstood. But not to worry.

    With the attached could you please populate the forrloing Tables.

    tblEquipment 3 Records
    tblEquipmentType 3 Records
    tblChecklist 40 Plus records
    tblChecklistAnswer One For each Checklist.

  3. #93
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    That took me ages without forms and default values, also may I add some answers will be incorrect as well as I do not know what some of the questions mean tbh.

    You will notice I also made the Answer2 field in answers table as well this is because every question has 2 parts the answer/ comment in addition to the 'yes, no or N/A' response which i made '1, 2, or 3' respectively

    As per the answers it is apparent that non-compliant answers will be the most different however all answers including yes and no answers are usually very different as well

    I think this is a fairly accurate, if not somewhat brief account of the questions and answers from the different check-lists

    Thanks

  4. #94
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Did you mean to attach something?

  5. #95
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    Ha... apologies

    Here it is now

    Attachment 4489

  6. #96
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    Hi Rain hope you had a good weekend, just a quick one with the check-lists table structure. Have I populated this database correctly (as you expected) and is the design correct/ still what you think may be the best way of doing things? Thanks

  7. #97
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Just needs a couple of adjustments.

    Will get back in a couple of hours.

    Just got to finish some work for a Client.

  8. #98
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    It doesn't appear to be any repeating Data in tblCheckList so that table appears correct.

    tblCheckListAnswer does have Repeating Data like, Clean, Not Sighted, Inspected and Sighted. You could have a Joint Table between tblCheckList and tblCheckListAnswer which would comply with the rules of Normalisation.

    But the amount of repeating Data at this stage does not appear to be significant so you may decide to leave this alone, unless of course with additional data there is likely to be much more repeats then you should eliminate the repeating data and create the Join Table.

  9. #99
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    OK that's good news I will start all the coding then if the structure looks good. fairly busy at the moment so may not get it done as quickly as I would like.

    There will no doubt be repeats of some questions and definitely some answers I think answers like sighted and not sighted will actually be repeated quite a bit inevitably as there will be very few non-compliances per inspection, in this case would you recommend a slightly different design. However it is not as easy as saying whenever someone chooses 1 then it is sighted as there will still be variation. Additionally if Non-compliant or 2 is selected than the answer will be different 99% of the time.


    If I then decide this is the design then I need to start coding the answers part of things and I assume I would do this in vb by saying something like if EquipmentTypeID= 8 then it opens this specific form (Example 2) and for each question validates by checklist id so if on this form the specific question is ChecklistID = 45 then default = Sighted in the forms text box/ combo box code and the value can only be 8 digits somehow in vb code as mask in the text or combo boxes code


    Is this correct?

  10. #100
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Go for it.

    But look at the opening times in that Database I sent you. The code behind it may help.

    It might be time to start a new as your future questions will be on Form design rather that Table structure.

    This will encourage other to help as well.

    I believe that all is fine to go but I am only human. So you may need to tweak things a little.

  11. #101
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    Excellent, I think I will do just that, thanks for everything you have been a great help.

  12. #102
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Just Noticed tblInspectionDetails.

    What are all the fields about???

    47 Fields are a lot.

  13. #103
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    Thanks Rain

    Not to worry about this one... must have been an old version where I had a check-list as a table - this has been superseded by tblChecklist now and there is no requirement for this table any longer.

  14. #104
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Thanks. Just checking.

Page 7 of 7 FirstFirst 1234567
Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA to check if a database is open
    By FSCHAMP in forum Programming
    Replies: 1
    Last Post: 04-28-2011, 08:20 AM
  2. How to print on pre printed check list
    By captgnvr in forum Reports
    Replies: 4
    Last Post: 05-13-2010, 08:15 AM
  3. Massive help from ground up
    By Steven.Allman in forum Access
    Replies: 14
    Last Post: 02-20-2010, 05:48 PM
  4. Replies: 1
    Last Post: 02-12-2010, 01:45 AM
  5. List box column check..
    By empyrean in forum Programming
    Replies: 1
    Last Post: 10-28-2009, 08:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums