06-03-2011 6:17 AM
Hi,
I have Table control program regarding to Equipment Log, where in output it show the Equipment details with Account assignment category, General settlement receiver, Shift Hours, Work Hours, Idle Hrs, Maint. Hrs., Production Hours etc...
In report, we have a formula i.e.
Shift Hrs. = Work Hours + Idle Hrs + Maint. Hrs. + Production Hours.
and all those fields are linked to each other.
If we want that Work Hours should be 0, then msg showing - Working Hrs. should be entered. , means without enter Working Hrs. value we cann't save it.
Now we removed the link of Working Hrs to others, means if we insert value 0 of Working Hrs., no msg showing. BUT Problem is this after remove this link, General settlement receiver value should not be saved.
We want Work Hrs. as 0 value and General settlement receiver value must not be BLANK. It should be Saved.
Plz guide..
06-03-2011 9:25 AM
hi
write a if statement after the Shift Hrs. = Work Hours + Idle Hrs + Maint. Hrs. + Production Hours.
if work hours = 0, message i000 with 'Working Hrs. should be entered'.
else ,write:/ shift hrs.end if. try to create a button for save when you click data will be saved or create a subrountine perform shift hrs than use if loop and select form end form inside keep Shift Hrs. = Work Hours + Idle Hrs + Maint. Hrs. + Production Hours.
thanking you
06-03-2011 9:25 AM
hi
write a if statement after the Shift Hrs. = Work Hours + Idle Hrs + Maint. Hrs. + Production Hours.
if work hours = 0, message i000 with 'Working Hrs. should be entered'.
else ,write:/ shift hrs.end if. try to create a button for save when you click data will be saved or create a subrountine perform shift hrs than use if loop and select form end form inside keep Shift Hrs. = Work Hours + Idle Hrs + Maint. Hrs. + Production Hours.
thanking you
06-06-2011 8:29 AM