S
Stephen
Is there a way to make the switchboard show items depending on the access
level of the person logged in?
level of the person logged in?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer [MVP]
Sure. Add a column in the switchboard table for permissions level Build a
table of usernames and permission levels. Use a query to link the 2 on the
permission level.
If you are not using user-level security to get the login identity, you can
use their Windows login username:
http://www.mvps.org/access/api/api0008.htm
That should get you started. POst back if you need more, with specific
questions.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
table of usernames and permission levels. Use a query to link the 2 on the
permission level.
If you are not using user-level security to get the login identity, you can
use their Windows login username:
http://www.mvps.org/access/api/api0008.htm
That should get you started. POst back if you need more, with specific
questions.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com