G
Guest
Hi,
I have a user table tbl_users with a bunch of users. There are 3 access
levels on my switchboard and on all forms in the form footer I have the
user_id and access level (number) shown. I want to make forms read only or
write and read only depending on the access level of the user.
Therefore I would have something like this:
if me.access = 1 then
give all access (tables, forms, reports etc)
else
end if
if me.access= 2 then
give write access (however do not let person do design or display database
window)
else
end if
if me.access=3 then
give read only access (user can only see forms as read only and access
reports)
else
end if
I also have my userid and access on a hidden form. So we could drive it
from there.
If forms!invisibleuserid.userid = 1 then
give all acccess
else
end if
etc etc etc.
Any one has any idea as to access levels and how to program it? Either
locking all fields. I want something fairly easy in terms of code that I
could put on my invisibleuserid form that would either
I have a user table tbl_users with a bunch of users. There are 3 access
levels on my switchboard and on all forms in the form footer I have the
user_id and access level (number) shown. I want to make forms read only or
write and read only depending on the access level of the user.
Therefore I would have something like this:
if me.access = 1 then
give all access (tables, forms, reports etc)
else
end if
if me.access= 2 then
give write access (however do not let person do design or display database
window)
else
end if
if me.access=3 then
give read only access (user can only see forms as read only and access
reports)
else
end if
I also have my userid and access on a hidden form. So we could drive it
from there.
If forms!invisibleuserid.userid = 1 then
give all acccess
else
end if
etc etc etc.
Any one has any idea as to access levels and how to program it? Either
locking all fields. I want something fairly easy in terms of code that I
could put on my invisibleuserid form that would either