Re: A complicated case with continous form
- From: "Dirk Goldgar" <dg@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Aug 2008 10:53:50 -0400
"heroddaji" <u45664@uwe> wrote in message news:890b2164de73b@xxxxxx
Hello, Can anyone help me with this case?
I have to display the working hours of workers in a form ,so I use continuous
form to display those values. the worker have 2 types of working hours, first
is 100% hours, 2nd is 150% hours.
If that guy work only 100%hours, then only show it. if he work also with 150%,
show 2 type of hours, and finally , if he work only 150%hours, show only 150%
hours. Here is an example
name percent hours
-------- ---------- ---------
a 100 8
-----------------------------------
b 100 7
-----------------------------------
c 100 9
150 2
-----------------------------------
d 150 4
my method is I use 2 text box for 100% and 150%, if that worker dont have any
150% hours,i will hide that textbox, so it take me 2 lines to keep 2 textbox
per worker, and make the form look not nice.( for example, if all the worker
have only 100%hours, the 150%hours is still there and take a lot of line).
I want to do something like if the worker dont have that kind of hours, the
line must be not there
my method example
name percent hours
-------- ---------- ---------
a 100 8
//this line is hide, because it have 150%hours textbox , while it support to
be for worker b
-----------------------------------
b 100 7
//this line is hide, because it have 150%hours textbox , while it support to
be for worker c
-----------------------------------
c 100 9
150 2
-----------------------------------
//this line is hide, because it have 100%hours textbox , while it support to
be for 150%hours.
d 150 4
This would be a lot easier to do with a report, not a form, because a report can use grouping and the Hide Duplicates property to handle this easily. In a continuous form, I can't think of a way to do it. In single form view, one could resize empty text boxes on the fly, but that won't work on a continuous form.
Could you use a report instead? Failing that, can you just make it one line across for each worker, with the different types of hours in separate columns?
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
.
- References:
- A complicated case with continous form
- From: heroddaji
- A complicated case with continous form
- Prev by Date: Pivot Chart
- Next by Date: Form Design Recommendation Tab and subforms
- Previous by thread: A complicated case with continous form
- Next by thread: Ebel Classic Mini Stainless Steel Ladies Watch 9003F11.9925
- Index(es):
Relevant Pages
|
