user permission forms

Hi

I have created a simple application to track projects. To limit who can see
which projects, I have a user table (which is used in the log in process),
user group table (with following groups: Owner, Admin, user)

I have another table called Users_on_Project which links the userID (PK)
from the User table to ProjectID (PK) in the Porjects table. This table
defines which users can access which project data.

If you belong to the Ower or Admin group, you can view all projects
regardless of the projects you are part of.

Everything works fine. but now I need a form to assign users to the
project. (ie. to insert/update/delete) records in the users_on_project table.
What is the best way to design a form to manage user permission for the
projects. I am thinking of a drop down combo of all the projects and two
list boxes: One listing all the users, and another one listing only the peple
working on this particular project.
two more command buttons to move users from one list to the other. (but I
have no idea how to update the table with VBA code)

Any ideas or sample forms are helpful

Thanks in advance.
Mohan

Hi Mohan,

Probably the best way would be to have a main form that lists user details
for a single user, with a subform that lists the projects that a user belongs
to. Very simple to set up and much less confusing than the multiple
selection listbox option IMHO.

Use a continuous subform with a combo box of Projects to select, link the
subform to the main form via UserID.

Hope that helps.

Damian.

"Mohan" wrote:

Hi

I have created a simple application to track projects. To limit who can see
which projects, I have a user table (which is used in the log in process),
user group table (with following groups: Owner, Admin, user)

I have another table called Users_on_Project which links the userID (PK)
from the User table to ProjectID (PK) in the Porjects table. This table
defines which users can access which project data.

If you belong to the Ower or Admin group, you can view all projects
regardless of the projects you are part of.

Everything works fine. but now I need a form to assign users to the
project. (ie. to insert/update/delete) records in the users_on_project table.
What is the best way to design a form to manage user permission for the
projects. I am thinking of a drop down combo of all the projects and two
list boxes: One listing all the users, and another one listing only the peple
working on this particular project.
two more command buttons to move users from one list to the other. (but I
have no idea how to update the table with VBA code)

Any ideas or sample forms are helpful

Thanks in advance.
Mohan

Thanks...

It worked perfectly

"Damian S" wrote:

Hi Mohan,

Probably the best way would be to have a main form that lists user details
for a single user, with a subform that lists the projects that a user belongs
to. Very simple to set up and much less confusing than the multiple
selection listbox option IMHO.

Use a continuous subform with a combo box of Projects to select, link the
subform to the main form via UserID.

Hope that helps.

Damian.

"Mohan" wrote:

Hi

I have created a simple application to track projects. To limit who can see
which projects, I have a user table (which is used in the log in process),
user group table (with following groups: Owner, Admin, user)

I have another table called Users_on_Project which links the userID (PK)
from the User table to ProjectID (PK) in the Porjects table. This table
defines which users can access which project data.

If you belong to the Ower or Admin group, you can view all projects
regardless of the projects you are part of.

Everything works fine. but now I need a form to assign users to the
project. (ie. to insert/update/delete) records in the users_on_project table.
What is the best way to design a form to manage user permission for the
projects. I am thinking of a drop down combo of all the projects and two
list boxes: One listing all the users, and another one listing only the peple
working on this particular project.
two more command buttons to move users from one list to the other. (but I
have no idea how to update the table with VBA code)

Any ideas or sample forms are helpful

Thanks in advance.
Mohan