Define Form Programmatically

[Guest]

For a timesheet application, my principal would like to review all charged
hours by project by project manager, with a total value of these hours
displayed on a form as follows:

Project # Project CD FF JF KS SF Total $
-----------------------------------------------------------------------------
06012 Main Library 12 10 10 10 10 4,780
[CB]
06013 Really Cool Project 8 8 8 0 0 2,640
[CB]

[CB] indicates a command button that when pressed, changes the status of the
records represented by these totals from 2 to 3, indicating they've been
invoiced.

The problem is that this crosstab is hard-wired into the form. If we gain
or lose an employee, we will have to change the form. I'd like to just
create the form programmatically depending on the current mix of active
employees. Can anyone point me in the right direction?

Thank you.

Sprinks

 

[Guest]

I'd make the 'crosstab' portion a subform. I'm assuming its a one-to-many
relationship (project to project manager) and you have the appropriate table
relationships set up.

-Dorian

 

[Guest]

Thanks for your response, Dorian. That is what I'd do also, a priori.
However, the compactness of one line per project (as there are 30-60 projects
open at any one time) is particularly convenient for the Principal.

On the other hand, if I could show a simple table of project and total $,
and allow him to click on something to show him the detail of hours, that
would work too, but I don't know how to do that. Can you help?

Thank you.

Sprinks

I'd make the 'crosstab' portion a subform. I'm assuming its a one-to-many
relationship (project to project manager) and you have the appropriate table
relationships set up.

-Dorian

For a timesheet application, my principal would like to review all charged
hours by project by project manager, with a total value of these hours
displayed on a form as follows:

Project # Project CD FF JF KS SF Total $
-----------------------------------------------------------------------------
06012 Main Library 12 10 10 10 10 4,780
[CB]
06013 Really Cool Project 8 8 8 0 0 2,640
[CB]

[CB] indicates a command button that when pressed, changes the status of the
records represented by these totals from 2 to 3, indicating they've been
invoiced.

The problem is that this crosstab is hard-wired into the form. If we gain
or lose an employee, we will have to change the form. I'd like to just
create the form programmatically depending on the current mix of active
employees. Can anyone point me in the right direction?

Thank you.

Sprinks