Making database user friendly

[ItIsHardToProgram]

I have a database that employees use but I had some memos about the database not being user friendly enough. Let me explain to you the problem.

I have a form that acts has a time sheet for the hours worked. The database is protected by a normal MDW of course.
When accessing the time sheets, the form only loads the time sheets of the user that logged in.

Here is where it gets a bit messed. The employers want the time sheets to be seperated by project number/type, which means a subdivision.

So far so good.....

Since the employers want employees to be able to add as much project subdivision as they want, i figured a datasheet was the best idea (if not point me in any other direction).

This is what they dislike: When they want to create a subdivision, they absolutely need to enter a project number, so if they forget, they get annoying messages that they don't understand.

For that problem, I was wondering if there was a way to, if anything is entered in the row, it stays on focus on the combobox until a selection of a project.

Normally I would probably have no problem doing so, the thing is, how can I do so in Data Sheet view.

I have a couple other problems involving the cloning of the recordset in seperate txtboxes but I can get to that later.

 

[JerryKlmns]

How about a form with 2 subforms?

Subform1 shows projects of the employee
Subform2 shows times on that project

Clicking on a project should show corresponding time. Adding a new project shows no time until they input some values?

 

[ItIsHardToProgram]

Problem is it needs to be seperated per week..... but i am not sure what you mean by showing the project and the time on that project.......

maybe you could be more specific, or explain a bit, thanks.

P.S. the main problem I want to fix is

I was wondering if there was a way to, if anything is entered in the row, it stays on focus on the combobox until a selection of a project.