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
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
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
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.
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