I have a timesheet form that I am converting to access (Currently
manual).
I can link 7 text boxes (days of week) for Vacation, Sick, Family
Sick... ect... per person to my db. Each week starts a new instance
in the db.
At the end of each row, I want to show the total for the week and
anything zero I want blank (The kicker) on the fly. If someone is
scheduled for vacation and I put 8 in a box, then I want the total
value to update immediately. If I find out they are actually here
and put zero in the 8's place, I want it to go blank. I can do this
with VBA but for all the different rows and not being able to use
arrays, it's going to take a lot of code over and over - even though
it's all doing the same thing.
It would look stupid to print out a timesheet with a hundred zero's
in it.
I was thinking of doind a combo of VBA and access default stuff but I
can't even show the total at the end of a row regardless of making
zero's blank.
Any help?
James
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
