Fransdekock
Registered User.
- Local time
- Today, 22:50
- Joined
- Jun 8, 2006
- Messages
- 18
Hi
I think i have a unique problem. I have a subform where the user type in number of days worked by a contractor in certain weeks. Standard fields are week1 to week 5. This subform gets its data from a query. The afterupdate for each week triggers a setvalue macro to take the contractors rate of that week cause it changes constantly and puts it into a historical record date field week1rate - week5rate so when u change the contractors rate u still know what his rate was that week so u can look at what his rates was months ago. So the problem i have is that cause the afterupdate events is full i need to update my total field which is week1rate * week1 and so on till week5(which keeps track of days or hours worked that week) and save it in the table. Can anyone help me cause i have run out of ideas plus i'm really not so good at VBA. Cause sometimes a user may go back and correct mistakes or misunderstandings about how many hours or days a contractor worked in a certain week1. And the total needs to calculate automatically again....
any help is much appreciated
I think i have a unique problem. I have a subform where the user type in number of days worked by a contractor in certain weeks. Standard fields are week1 to week 5. This subform gets its data from a query. The afterupdate for each week triggers a setvalue macro to take the contractors rate of that week cause it changes constantly and puts it into a historical record date field week1rate - week5rate so when u change the contractors rate u still know what his rate was that week so u can look at what his rates was months ago. So the problem i have is that cause the afterupdate events is full i need to update my total field which is week1rate * week1 and so on till week5(which keeps track of days or hours worked that week) and save it in the table. Can anyone help me cause i have run out of ideas plus i'm really not so good at VBA. Cause sometimes a user may go back and correct mistakes or misunderstandings about how many hours or days a contractor worked in a certain week1. And the total needs to calculate automatically again....
any help is much appreciated
