Hide/disable certain buttons on custom ribbon bar in access 2007

I have created a custom ribbon bar for my A2007 DB but wanted to know if there was a way to disable and/or hid certain buttons on the ribbon based on a users permission level? I have a table called "tblEmployees" where I can add permission levels but I want to be able to disable certain buttons on the custom ribbon bar. Is this possible? If so, can anyone shed some light on how I would do this?
LVL 1
Lawrence SalvucciInformation Technology ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BitsqueezerCommented:
Hi,

this is done using Callback functions which must be in a standard module and declared as Public. You can find all the details about ribbons including demo databases and code snippets here:

http://www.accessribbon.de/en/

Cheers,

Christian
0
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
I understand how to enable them and disable them but how do I do it based on a user's permissions?
0
Jack LeachProprietorCommented:
By using a callback function, you gain access to your entire project via VBA, so you can then check for any active user/permissions from within your code, and return your callback values accordingly.

I forget the attribute name offhand, but the visibility/enabled status will be set according to whatever the callback returns, thus you have the entire project at your disposal for logical handling through the callback.

Cheers,
-jack
0
Gustav BrockCIOCommented:
Yes, it is possible, but it will be a lot easier for you if you implement the ribbon class module from Albert D. Kallal:

http://kallal.ca/Ribbon/ribbon.htm

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.