Fransdekock
Registered User.
- Local time
- Today, 22:43
- 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....
I have a macro that calculates this....called total but if i put that in ontimer event the problem is tries to create new record and gives problems cause the subform is also used for new data entry
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....
I have a macro that calculates this....called total but if i put that in ontimer event the problem is tries to create new record and gives problems cause the subform is also used for new data entry
any help is much appreciated
