T
Thiazi
I have a table in which I have a list of names who are assigned to
certain categories. Is it possible to limit the values that appear in
a Combo Box based on the username of the user accessing the database?
(So essentially, I'll have to create a separate table I guess that
defines which usernames have access to which categories.)
I've done a bit of research and found that environ("username"), while
it can be circumvented, identifies the username and can be used in the
code. For this application, that's more than sufficient.
So would I create a separate table associating usernames with the
categories, link the two together, and then the code would be an if/
then situation? If Environ("Username") = "thisusername" Then?
certain categories. Is it possible to limit the values that appear in
a Combo Box based on the username of the user accessing the database?
(So essentially, I'll have to create a separate table I guess that
defines which usernames have access to which categories.)
I've done a bit of research and found that environ("username"), while
it can be circumvented, identifies the username and can be used in the
code. For this application, that's more than sufficient.
So would I create a separate table associating usernames with the
categories, link the two together, and then the code would be an if/
then situation? If Environ("Username") = "thisusername" Then?