help me please

[jbarna]

i have a production data base and i have created a form with a sub
from to enter daily prodution.
the main form has employee info (name , id number )
which is from an employee table, the sub form connect to the main by
employee to input info such as start time machine number hours of
production and efficency ect. my problem is that i need to check on a
daily to make shure all employees in formation was imputed. i have two
ideas on what to do just dont know how.
the first is to use the main employee form as a check list to some how
after i iput all the infromation for that employee for that date check
off that employee and if an employee is not enterd for that day have a
message box tell me the missimg employee?
or when i click the date button run code to bring up a list of
employees for that day and select an emplyee and and imput it into the
form and remove that employee form the list and keep doint that until
i am done.


any one have any ideas???

 

[Guest]

Hi

An easy solution (not the only one) would be to create an extra field in the
table holding the subform's data. Make this new field a time/date format.

Have an event on the subform (onchange, etc) that inputs the date (or time
and date) into this new field.

This has the benifit that not only can you use a query to see if an employee
was updated that day but you could only use the new field to filter many
reports showing daily "stuff".

You will be able to make a simply datasheet form to show which emplyees have
not been updated on any date (either use today or prompt for a date)

Hope this helps

 

[John W. Vinson]

my problem is that i need to check on a
daily to make shure all employees in formation was imputed. i have two
ideas on what to do just dont know how.

The first thing to realize is that you are NOT storing the data in your Form.
The form is only a tool, a window; the data is stored in your Tables, and only
in your Tables!

Secondly - surely some employees are legitimately absent on some days? You
wouldn't input employee biographical information every day - but there may
well be some days when Fred is on vacation, and Jose is out sick, and Rosie is
on jury duty, and you wouldn't have any data to input.

You can create an "Unmatched Query Wizard" query to find all employees who do
NOT have data entered on a particular day (looking at the tables where the
data is, not at the form).

John W. Vinson [MVP]