Need a repeating Detail Section in the form

[Shamli]

Hello Everyone
I am working on timesheet Management system.
Each employee is assigned to one or more projects.
Timesheet entries are in the detail section.

I need the detail section to be repeated.
Like an additional section for each employee depending upon the number of projects they are assigned to.



Could you please tell me a way to do it.
I have attached the screenshot of the repeating detail section.

[NoellaG]

Have you tried a continuous subform? I suppose your data are linked with a one to many relation from head info -> detail info. Than you can easily use a subform to show the detail info from the many side of the relation.

[Shamli]

I am using a continuous form instead.
Yes they are in one to many relationships.

Have you tried a continuous subform? I suppose your data are linked with a one to many relation from head info -> detail info. Than you can easily use a subform to show the detail info from the many side of the relation.

[NoellaG]

The easiest way is to use a single form to display the main info (for example project, WBS,..), and put the many info (example, employee, date and hours) in a separate continuous form. To see what's the best choice, we need to know the database structure.

[Shamli]

There are many projects being assigned to an employee.
This is the reason the employee details are kept in the form header and the project details are kept in the form detail section (Continuous).

The easiest way is to use a single form to display the main info (for example project, WBS,..), and put the many info (example, employee, date and hours) in a separate continuous form. To see what's the best choice, we need to know the database structure.

[Shamli]

I have attached the DB for your reference.
Please have a look.

[Shamli]

Its like adding new record as soon as you enter something in the previous record.

[Shamli]

can anyone please help me with this.
I am stuck coz of this issue.

[June7]

I did look at and quickly ran away. That spiderweb of relationships is frightening. Perhaps you should look at MS Access Timecard database template. However, if you want to stick with the design of field for each day of week, that template may not be what you want.

When opening, database autoloads a form which triggers popup inputs. I just enter past those and form opens but then I can't close it. I have to close the db and reopen with shift key by-pass. Why set db to open to data entry form instead of the menu form? I tried opening the menu form and get errors.

Not making it easy nor appealing for anyone to review.


The detail section will be 'repeated' when there are records. Don't really understand what you are asking for.

None of the forms are a form/subform design. And one form is totally empty.

[orange]

I agree with June -- confusing, not intuitive.
Perhaps you could show us
-an overview of the project/database i simple terms
-some detailed requirements
-some samples of what a completed form would look like

[Shamli]

Sorry about that.
Since I wanted to remove the confidential data. It made a mess here.
I am trying now to give the structure of the table.

I did look at and quickly ran away. That spiderweb of relationships is frightening. Perhaps you should look at MS Access Timecard database template. However, if you want to stick with the design of field for each day of week, that template may not be what you want.

When opening, database autoloads a form which triggers popup inputs. I just enter past those and form opens but then I can't close it. I have to close the db and reopen with shift key by-pass. Why set db to open to data entry form instead of the menu form? I tried opening the menu form and get errors.

Not making it easy nor appealing for anyone to review.


The detail section will be 'repeated' when there are records. Don't really understand what you are asking for.

None of the forms are a form/subform design. And one form is totally empty.

[Shamli]

I have updated my database.

Overview of the Project:
Its a timesheet Management system.
An employee can be allotted to many projects and many tasks. (Many to Many)
An element can have many projects. (One to many relationships)


Forms to be focused:
New Timesheet Main F:
The Main Form where the employees can enter new timesheet, edit existing one and print report etc.
Create a new entry:
This form is where the employees enter their timesheet.
New Timesheet Main F Admin:
This is the admin page. Where the admin can assign/Remove employees to projects and to tasks.

Usually the employee ID box from the Create a new entry takes from employee login from the system. Here I have edited as a manual pick up.

1. What it should actually do:
So when the employee has been given access to 2 projects.
He goes to the timesheet and enter his hours for the two projects and close it.
And then when he reopens for the next week, the element, Project details should be as it is and only the hours to be entered is suppose to "0". Where he enters the hours for next week.

And when the admin deletes a project under the employee name.
When the employee opens his timesheet, the previously entered project details (Which was removed by the admin for the current week) should be removed.

What it does:
But now, Even when the Project is being removed, that row appears and when we do select the dropdown of the element box , the data is removed.

2. Task Field should be Mandatory in the timesheet. And it should be entered after the employee finish entering his project details.

Please help me with this.

[Shamli]

Am I missing out anything?

I did look at and quickly ran away. That spiderweb of relationships is frightening. Perhaps you should look at MS Access Timecard database template. However, if you want to stick with the design of field for each day of week, that template may not be what you want.

When opening, database autoloads a form which triggers popup inputs. I just enter past those and form opens but then I can't close it. I have to close the db and reopen with shift key by-pass. Why set db to open to data entry form instead of the menu form? I tried opening the menu form and get errors.

Not making it easy nor appealing for anyone to review.


The detail section will be 'repeated' when there are records. Don't really understand what you are asking for.

None of the forms are a form/subform design. And one form is totally empty.