Resource schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a form with the left hand column/field as the employee name,
followed by a column for each day of the week. Each record would contain a
time allocation of an employee to a given project no. entered under the
appropriate day. So far no problem.

Question: How can I scroll the seven days/fields backwards and forwards
through the calendar year?

Much thanks in advance
 
I want to create a form with the left hand column/field as the employee name,
followed by a column for each day of the week. Each record would contain a
time allocation of an employee to a given project no. entered under the
appropriate day. So far no problem.

Question: How can I scroll the seven days/fields backwards and forwards
through the calendar year?
Click to expand...

Well, not by storing the data in a table such as you describe. Storing
data in fieldnames (days of the week) is simply incorrect
normalization!

You can *DISPLAY* data in this way using a Crosstab query, based on a
properly normalized table with fields for EmployeeID, AssignmentDate,
and ProjectNo. This will let you very flexibly display any desired
range of dates.

John W. Vinson[MVP]
 
Thanks for help John, but to be more explicit, I want to enter data into the
form. Can I do this through a crosstab query in Acceess Project?

Thanks again
 
Your data entry form should never "drive" your table structure. If you
really need to enter data into a form like that, you may need to use code or
temporary data entry tables.
 
Thanks for help John, but to be more explicit, I want to enter data into the
form. Can I do this through a crosstab query in Acceess Project?
Click to expand...

Unfortunately, no; a crosstab query is never updateable.

You'll need to follow Duane's advice - either restructure your form,
use a non-normalized temp table, or (probably best but hardest) use an
unbound form and some VBA code to move data around and change the
appearance of the form to match the data.

John W. Vinson[MVP]
 
Back
Top