Dynamically change order of buttons on a form (1 Viewer)

amaklop · Sep 23, 2018

Hi

I have a home page with various buttons. Depending on the user's security group, only certain buttons will be available. However, when the buttons are hidden that he cannot see, there are big gaps between the buttons. Is there a way that I can "auto arrange" the buttons after I've hidden the ones he cannot see? I'm trying to get each users' home screen to have all the buttons left aligned and overflow into the second column if the first is full.

Is this possible?

Gasman · Sep 23, 2018

The default switchboard works like that I seem to recall.
Each menu entry is in a table and you decide what is presented to the user.?

Check out the SwitchBoard Manager in Database tools.

isladogs · Sep 23, 2018

Yes its possible but it will need a fair bit of code and it might cause a performance hit.

Does it really matter? If it does, why not just disable rather than hide the buttons?

amaklop · Sep 23, 2018

Ahh ... Thanks I never thought of disabling the buttons. That will be much easier

isladogs · Sep 23, 2018

You're welcome.
If you have a lot of buttons to disable or multiple conditions you may find using the Tag property helps reduce the amount of code needed.
See this example application https://www.access-programmers.co.uk/forums/showthread.php?t=293439

isladogs · Sep 23, 2018

Amalkp
You have cross posted this and had answers on at least 3 forums.
Please read this article about why it matters and the correct etiquette if you do cross post https://www.excelguru.ca/content.php?184

Dynamically change order of buttons on a form (1 Viewer)

amaklop

Registered User.

Gasman

Enthusiastic Amateur

isladogs

MVP / VIP

amaklop

Registered User.

isladogs

MVP / VIP

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread