Displaying only employees with data in subform

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

I created a form, where the main form only shows the employees from the
employee list.

There are 2 subforms, each displaying current weeks payroll entries. The
first subform shows each day of the week with the hours worked, earnings
code and job. The second subforms shows the total hours per week by job.
The whole reason for this form is to display data and correct errors between
the 2 subforms. The subforms are updatable.
When I scroll through the entries, it display all employees even if they did
not work.

Where do set to show only employees that have data in either subform?

If I use the employee name from the subform, the employee shows up several
times, once for each entry.
 
-----Original Message-----
I created a form, where the main form only shows the employees from the
employee list.

There are 2 subforms, each displaying current weeks payroll entries. The
first subform shows each day of the week with the hours worked, earnings
code and job. The second subforms shows the total hours per week by job.
The whole reason for this form is to display data and correct errors between
the 2 subforms. The subforms are updatable.
When I scroll through the entries, it display all employees even if they did
not work.

Where do set to show only employees that have data in either subform?

If I use the employee name from the subform, the employee shows up several
times, once for each entry.


.
Create a query and join the employeeID fields between the
Click to expand...
table that has your subforms data and the table that has
you main form data. In the join properties select the one
that says show all records from the subform and only those
that match from the main form.
 
That creates another problem. Both subforms consist of several records for
each employee. When I did that, it would go through each record for the
employee. For example, if the subform showed 3 records, you have to click 3
times next to go to the next employee.
Since this is only for checking out differences which were established in a
query, the find button works very well to find a specific employee. To make
it easier for the user to search, I would like to add a default search
criteria to search by employee name field, search by start of field and
search all.
I am sure this could be done through vba but I wouldn't know how to do that.
Can someone tell me, what I would have to add to the search button criteria.
Please be very specific.
 
if you're stilling having trouble with this, annelie, and
nobody else helps you fix it, i'll look at it for you if
you want to send me a copy of your db. i can probably set
it up the way you want, and send it back so you can see
it - i'm just not always good at visualizing in theory and
explaining in print. i have Access 2000, so can look at a
97 or 2000 db.
 
Back
Top