Stop macro based on user-level security

[Guest]

I have a database that I assigned user-level security to stop certain users
from create/update/delete data and thus blocking access to certain forms.
Normally to access these forms a user will click a button, depending on type
of form i.e. create, details (read-only), or update. The button was created
using a macro. When a restricted user (read-only) clicks on, for ex.
"Create" button, they successfully receive a message stating they do not have
sufficient permission. But then my macro fails and an "Action Failed" window
appears with option to Halt macro.

I would like to either set a condition in macro or add code to automatically
halt or stop macro behind the scenes. Does anyone know if this is possible
(based on user-level security)?

 

[John Nurick]

This is possible in VBA but not, as far as I know, with macros.

 

[Guest]

I have converted the macro to vba ... I thought I would be able to use code
to call macro and then use and if...then statement to halt macro if action
failed.

 

[John Nurick]

Either set up error handling and trap the errors, or - and much better -
write code that checks the user's group membership (see e.g.
http://www.access-programmers.co.uk/forums/archive/index.php/t-70864.html)
when the form loads and adjusts the Visible or Enabled properties of the
buttons accordingly.

 

[Guest]

Thanks, but I didnt have to go to that extent... the security automatically
displayed message stating cant open form. All my code has is the open form
command. That was suffice. Thanks for the information, it was very helpful
and will consider for future.