Disable control

  • Thread starter Thread starter shiro
  • Start date Start date
S

shiro

Hi All,
Is it possible to disable a control such as command button
to a certain user?.How to do that?
 
If you've implemented user level security, you can use the CurrentUser() function to grab their Access username. I would make the button invisible rather than disabled.

If CurrentUser() = 'shiro' then
Me.cmdWhatever.Visible = False
Else
Me.cmdWhatever.Visible = True
End If

You can also do this based on the group rather than just the user. There's code in the security FAQ you can use to determine if a user is a member of a group.
http://support.microsoft.com/?id=207793

If you haven't used ULS, then you can grab the user's Windows login name and act on that. You'll find the code to retrieve this at
http://www.mvps.org/access/api/api0008.htm
 
Thank's Joan,
But more question:
After implement user level security wizard,Why does
my user cannot open/run the query in the database?




If you've implemented user level security, you can use the CurrentUser()
function to grab their Access username. I would make the button invisible
rather than disabled.

If CurrentUser() = 'shiro' then
Me.cmdWhatever.Visible = False
Else
Me.cmdWhatever.Visible = True
End If

You can also do this based on the group rather than just the user. There's
code in the security FAQ you can use to determine if a user is a member of a
group.
http://support.microsoft.com/?id=207793

If you haven't used ULS, then you can grab the user's Windows login name and
act on that. You'll find the code to retrieve this at
http://www.mvps.org/access/api/api0008.htm
 
The user (or a group they are a member of) need at minimum Read Data permissions on the query. In addition you should set the Run permissions property of the query (View, Properties in design view) to Owner.
 
I've set the query's run permission to owner.but still get the same.
It just occured to action querys.
When I see the User/Group permission in security menu,
the option Open/Run of query is disabled.Any suggestion?.


The user (or a group they are a member of) need at minimum Read Data
permissions on the query. In addition you should set the Run permissions
property of the query (View, Properties in design view) to Owner.
 
You need to give the users Read Data permission on the query. There is no Open/Run permission on a query.
 
I did Joan,
I have check the option read data for that user.
But still unable to open/run the query


You need to give the users Read Data permission on the query. There is no
Open/Run permission on a query.
 
'Run Time Error 3033'

"You on't have the necessary permission to use the 'query' object.
Have your system administrator or the person who created
this object estabilish the appropriate permission for you. "


What message do you get when you try to open the query as the user?
 
Does it actually say 'query' or does it say the name of some query? You need to give as a minimum 'Read Data' permission on that query.
 
I did Joan,
I guve Read Data permission for all querys
in my db.


Does it actually say 'query' or does it say the name of some query? You
need to give as a minimum 'Read Data' permission on that query.
 
'Monthly Sales Report'
'Pivot Excel' .
That they are.

What is the actual name of the object given in the message in the single
quotes?
 
And what permissions do the users have on 'Monthly Sales Report' (I take it this is a report?) and 'Pivot Excel'?
 
Their ability are :
Read Design,Read Data,Insert Data,and Update Data
for both tables and querys.


And what permissions do the users have on 'Monthly Sales Report' (I take it
this is a report?) and 'Pivot Excel'?
 
You have to remember that I can't see what you are seeing on screen.

You are getting a message that you don't have permission to 'some' object (be it a table/query/form/report). You need to double check the permissions on *that* object. Clearly the user does not have the right permissions.
 
Back
Top