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 2
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor 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
 
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
 
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAuthor Commented:
Thank you so much at least I have now somewhere to start
0
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.

All Courses

From novice to tech pro — start learning today.