B
Buddy
I'm in the beginning stages of creating a database that will be used
on a factory floor via a touch screen interface. This db will ask the
workers a series of questions via combo boxes, text boxes, etc, in
order to generate a serial number and keep track of who is working in
each line as well as productivity.
More specifically, the opening screen will ask employees which
facility they are working in (combo box) and what shift they are
working (combo box). Since there are usually 3 or 4 workers per line
in the factory, they will then each have to enter their employee ID
numbers to "log in." I'm not sure if I will use a textbox or combo
list interface for this part yet. However, once logged in, they will
be asked 2 more questions for report purposes later.
I'm not sure how to go about implementing this login feature. I
already have an employee table setup with their names and ID numbers.
But how can I let the users "log out" without exiting Access? For
instance, if the people working in a line change, they will need to
log out and go back to the employee ID screen so they can adjust who
is working on the current team.
Furthermore, how can I save the "team" of workers to a table to once
they are logged in, to see how many products they have pushed out
during the time they were active? I'm kind of new to this, so I
appreciate all the help.
Thanks in advance,
Buddy ([email protected])
on a factory floor via a touch screen interface. This db will ask the
workers a series of questions via combo boxes, text boxes, etc, in
order to generate a serial number and keep track of who is working in
each line as well as productivity.
More specifically, the opening screen will ask employees which
facility they are working in (combo box) and what shift they are
working (combo box). Since there are usually 3 or 4 workers per line
in the factory, they will then each have to enter their employee ID
numbers to "log in." I'm not sure if I will use a textbox or combo
list interface for this part yet. However, once logged in, they will
be asked 2 more questions for report purposes later.
I'm not sure how to go about implementing this login feature. I
already have an employee table setup with their names and ID numbers.
But how can I let the users "log out" without exiting Access? For
instance, if the people working in a line change, they will need to
log out and go back to the employee ID screen so they can adjust who
is working on the current team.
Furthermore, how can I save the "team" of workers to a table to once
they are logged in, to see how many products they have pushed out
during the time they were active? I'm kind of new to this, so I
appreciate all the help.
Thanks in advance,
Buddy ([email protected])