Question Restrict use

[SFCM]

Hello, Can someone tell me, I have a human resourse data base that I have created. I have certain reports that only management needs to view. is there any way to make just those reports accessible by a login without affecting the main user access?

I have tried looking it up in google, but I have not found an answer. I have never had any formal triaining, everything I have learned about access I have done by trail, error, and google. Thanks in advance.

 

[PaulO]

Yes, by recognising each user's LAN ID within relevant open Forms you can then enable/disable command buttons by reference to the LAN ID

the expression you need to use to trap the LAN ID is, I believe:-

=Environ$("USERNAME")

The 'Permissions' table, which you can query against, can be as simple as
LAN ID; Group (where group is either Management or Other)

Just my thoughts ...

 

[CBrighton]

I use this all the time.

I find the easiest way to do it is to display the LAN ID (and/or the access level from a table like the one mentioned in the post above) in a control on the switchboard (.visible = false so it's not seen by the user) and check that control each time I need to check permissions.

 

[SFCM]

I will try and learn how to do this thank you. at least i have a place to start now