Results 1 to 8 of 8
  1. #1
    Join Date
    May 2003
    Posts
    4

    Unanswered: Please help my job depends on this

    Hi to everybody
    I know it is looking a bit dramatic the title of my post but i am not joking!
    I have this problem and i really don't have a clue how to solve it
    And by the way i can really describe it because i don't know which method i should use
    So lets go to the problem and hopefully my boss won't fire me(I am not joking i am 100% honest about this it is all a matter of time)
    I have a form based on a rather huge table with about 100 filelds probably they will get more on the way
    I will put 63 records this week (the records are about some houses my company is building; each home a separate record ok?) and the problems is
    Every record has about 40 checkboxes about works each house is needed(for example house1 needs painting,heating,plumbing etc , house2 needs plumbing,heating,fences etc and the list goes on) and to get the information straight these works are standards( i split them in 2 parts i)works to be done - ii)works that this week are going to get done)
    So for this week i will have for all these 63 houses a perfect report to give to my boss(he will see that house1 has for example 5 works undergoing and about 3 to get done and this goes the same fot all the others) but the problems arise for next week ---->
    Next week i will have some data for example for house14 that plumbing is done and we are going to make the heating and this is the big question how when i put this new record for house 14 (with all these checkboxes i mentioned) and for the sake of example lets say that i have data for 15 houses how i will get :
    1ST my new records when i pick a house that has an old rcord(i don't know if i am making myself completly understood eg house14 on this week has 3 works undergoing and 5 more to come
    house14 next week has completed 2 of the 3 works last week and now has 6 works to get done) i want to come will all the old values present(for example i have checked plumbing and electricals for this week i want them to be checked again when i move to the next record so i get the information if they need to be still checked or not) and
    2ND my records who had no update(for example house nothing was done in house21 it is still the same works for next week as it has this week and no progress was made) are copied to the next week(sorry for the examples but i am really i a very bad situation and i am desperate to say the least again one more example:
    week20 house3 has plumbing,heating,roof .......
    week20 house15 has heating,roof,painting....
    week20 house35 has painting,tiles,fences....

    lets move to next week
    week21 house3 & house15 &house35 when i select them as new records for week 21 come with all the old values in the checkboxes but i have made progress with house3 and its plumbing so i uncheck plumbing and similar for house15 for its roof but now i a new job e.g fencesso i check fences and house35 stays as it was with no changes.
    So when i go to print my report for week21 i will have an updated house3 & house15 but house35 carries the old values and my report has all these 63 records i mentioned before
    Please bear in mind that anytime these 63 records can easily go up or down(a new house or house that although was ready to get build the owner change it mind)
    As i said before i can really describe what i need and i have very little knowledge of access and vba but i surely as hell want to keep my job
    If anyone can help me i would be much obliged to say the least
    PS sorry for the length of this post and for the many examples but when someone is deperate is desperate
    Please have a look at my attachment and help me
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    i think you might have a table structure problem: here's my first thoughts:


    -tblHouses
    houseID, auto, primary
    ...and whatever else relates to the house itself

    -tblContractor
    contractorID, auto, primary
    ...and their address etc etc

    -tblJobs
    jobID, auto, primary
    jobType, text (e.g. fix fence, cut grass, paint wall)


    -tblSchedule
    scheduleID, auto, primary
    houseID, lookup on tblHouses
    jobID, lookup on tblJobs
    contractorID, lookup on tblContractor
    isScheduled, boolean (true when you have fixed a date to do this job)
    isDone, boolean (true when done)
    doBy, ...your choice of: week number (God i hate week numbers!) or date of last day of week (please!!!)
    doneOn, date (when the job actually got completed)

    from this structure you can use real simple queries to find all jobs -completed -pending -scheduled -delayed; which contractors screwed up the most; which houses are/are not under control; what is the most frequent job request; average delay beyond schedule by -house -contractor -job -month; what's due now; what's overdue; what's done; ... etc

    izy

  3. #3
    Join Date
    May 2003
    Posts
    4

    Thanks a lot for the reply

    Thanks a lot for the reply
    I am currently working on your suggestion
    But i don't know if you have downloaded the attachment
    The real problem is on the week change when you select a house to populate the form with the values of last's week in order to see what is going on and then all these are saved correctly in the table/query
    Anyway i am gratefull for your reply

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    i can't make it work (errors on _click the arrow on your startup, also errors in _enter when i start your main form directly). attempts to see database properties fail.


    izy

  5. #5
    Join Date
    May 2003
    Posts
    4

    Thanks for replying

    Thanks for replying
    Which version of access are you using izyrider; if you need a 97 version i can attach one

  6. #6
    Join Date
    Feb 2002
    Posts
    403
    I think that you have two problems here. One is politic and the other is an Access problem.

    The politic problem needs addressing as much if not more than the Acess problem. If your job is truly dependant on your ability in Access to design this type of report, you need to be up front, tell your boss you are struggling with Access and that you need further training. Show him some courses you have found maybe at your local polytech that will bring you up to speed fairly quickly and in the meantime use the forums and polytech as resources to really come to terms with Access.

    The Access part I will have a look at now.

  7. #7
    Join Date
    Feb 2002
    Posts
    403
    Have a look at the table structure changes, the queries and the form cahnges.
    Attached Files Attached Files

  8. #8
    Join Date
    May 2003
    Posts
    4
    Thanks for the reply although is not an answer to the problem i have
    The whole point is when we advance to next week all the old records to get stored automatically and if you choose some houses to update to come with the old values pre-checked and all the rest of other houses to keep the old values and carry them automatically to the next week

Posting Permissions

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