update new records

[Guest]

I would like to create a form that calls up all records(employees) and amends
their attendance for the new date. I would like to see and edit all
associates, if possible at the same time. I am haing trouble finding how to
create the subform for this.

 

[Joseph Meehan]

I would like to create a form that calls up all records(employees)
and amends their attendance for the new date. I would like to see
and edit all associates, if possible at the same time. I am haing
trouble finding how to create the subform for this.

I am at a loss as to why you would want a sub form? Maybe you could
explain a little more detail about what you want and what you are doing?

 

[John Vinson]

I would like to create a form that calls up all records(employees) and amends
their attendance for the new date. I would like to see and edit all
associates, if possible at the same time. I am haing trouble finding how to
create the subform for this.

A Continuous Subform will display multiple records (view the form's
Properties and set its Default View to Continuous).

If you want to update all records in a table, automatically without
typing data into all of them, an Update query would be the appropriate
tool.

I'm not at all clear what you want updated though!

John W. Vinson[MVP]

 

[Guest]

I have three tables.
Associates:
ID-pk
Last Name
First Name

Associate Stats:
ID PK
Hire Date
other important data

Attendance:
ID pk
Date
Time in
Time out
other daily data

What I am trying to do is find an easier way do enter information for all
employees at the same time, like a spreadsheet. When I use the form wizard
it sets up a subform for each employee record, and I have to scroll through
each individual and key data. Is it possible to call this data all ot one
time? Maybe I'm missing something.

Cheers,
m

 

[Joseph Meehan]

I have three tables.
Associates:
ID-pk
Last Name
First Name

Associate Stats:
ID PK
Hire Date
other important data

Attendance:
ID pk
Date
Time in
Time out
other daily data

What I am trying to do is find an easier way do enter information for
all employees at the same time, like a spreadsheet. When I use the
form wizard it sets up a subform for each employee record, and I have
to scroll through each individual and key data. Is it possible to
call this data all ot one time? Maybe I'm missing something.

Cheers,
m

Table design looks OK, but I might combine the first two unless that is
something other than a 1:1 relationship.

I now know what you want, and I have a number of ideas of how to get
there, but I have not really tied doing it. Most of my ideas should work,
but they all seem rather forced. I'll have to think about it for a while.
I seem to be working on the idea of creating a set of blank records, one for
each employee maybe using an append query, then editing the results. What I
don't like would be the awkward adjustments for vacations etc.