In my dashboard Tools need to arrange when we hide button for some user. But here these place is empty display.
I would like it automatically arrange when hide icon or button not gap or blank.
Can It possible.
I tried it. its worked. See post #5
But each command I have separated top a picture/Icon. Picture is not with same Button. It is need separated.
I also tried to same button but same I can't find SIZE MODE OPTION. can you give a demo with picture.
I have a dashboard for 3 Users. In dashboard 4 lists box where condition that double click to open main form.
So, I need some condition by Each user that If he/she click this list box and he/she does not able to EDIT Or ADD any data.
I TRIED to Disabled list box, but user give complain then she need to see data sometime.
Question :
Where I have to put these condition.
To allow a user access to a record but not allow updates, use the form's BeforeUpdate event. Since the user is opening a separate form, the code needs to go into the form the user opened, not the dashboard form.
Code:
If "somecondition indicating that the user does NOT have access" Then
msgbox "You do not have permission to update this record.", vbOKOnly
Me.Undo '' back out all changes to the record.
Cancel = True '' Tell Access to not save the changes
Exit Sub
End If
.....
Do the rest of your validation to determine if there are any errors.
To allow a user access to a record but not allow updates, use the form's BeforeUpdate event. Since the user is opening a separate form, the code needs to go into the form the user opened, not the dashboard form.
Code:
If "somecondition indicating that the user does NOT have access" Then
msgbox "You do not have permission to update this record.", vbOKOnly
Me.Undo '' back out all changes to the record.
Cancel = True '' Tell Access to not save the changes
Exit Sub
End If
.....
Do the rest of your validation to determine if there are any errors.