Hiding a Button on the menu form

I have created a form menu in my application which has buttons created where people are able to choose where to go , but they are created using the macro wizard not VBA.

(1) Is it possible to hide  these buttons , for example , the objective here is that there some button which are allocated to administrators, accountants , managers  and data entries clerks , I want my form to show only those buttons  relating to user rights. For example the current application does not allow anyone to use all the buttons unless one is not a data entry clerk.

(2) I was also thinking of ways of creating drop downs menus  instead of buttons is it possible in access? I do not to use access built switchboard , it is not okay for huge projects

Regards

Chris
LVL 3
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

ste5anSenior DeveloperCommented:
What Access version? What project type? Cause I prefer using the Ribbon for that.

And why have you tagged your post Golang? This is the Go programming language from Google..
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<(1) Is it possible to hide  these buttons >>

  Yes.  Generally you would do this in the OnLoad event of the form.

<<(2) I was also thinking of ways of creating drop downs menus  instead of buttons is it possible in access?>>

 With later versions you are stuck with the ribbon and yes, you can create your own.   This is the best site for things related to that:

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

Lots of good info there and the tool, but you will be moving into using VBA.  And I would suggest that your learn VBA.  Working with Macro's is difficult.

There's also this article, which is a general overview of the ribbon and how to use it:

https://support.office.com/en-us/article/Customize-the-Ribbon-45e110b9-531c-46ed-ab3a-4e25bc9413de

Jim.
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
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAuthor Commented:
Thank you so much at least I have now somewhere to start
0
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.