Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-15-2018, 03:00 AM   #1
supersonic
Newly Registered User
 
Join Date: May 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
supersonic is on a distinguished road
Question Custom Ribbons - Show/Hide groups

Hi all

I have created a custom Ribbon and I understand that it is only possible to load one Ribbon at a time in Access; if I need to open a different Ribbon, Access needs to be restarted even if I use VBA.

I have to create an employee database and different people will have access to it and Access shall display groups based on the login provided. The Ribbon has the following three groups to start with:

grpHome
grpAdmin
grpEmployee

There is already a post about this topic at access-programmers.co.uk/forums/showthread.php?t=246015 . However, I don't know where in the example provided by Ari I set the name of groups.

Is it possible to show/hide the groups with VBA by providing the name of the group?

Thank you for your assistance

SuperSonic
Attached Files
File Type: accdb Employees.accdb (448.0 KB, 7 views)

supersonic is offline   Reply With Quote
Old 09-15-2018, 09:19 AM   #2
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,131
Thanks: 83
Thanked 1,508 Times in 1,408 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
Re: Custom Ribbons - Show/Hide groups

You have used the IDBE Ribbon Creator software to create your ribbon. On the IDBE website there are a large number of tutorials which may include an answer to your question

I recommend you rename your ribbon which you have named Home. There is a built in Access ribbon with that name.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

New example databases:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 09-15-2018, 10:51 AM   #3
June7
Newly Registered User
 
Join Date: Mar 2014
Posts: 579
Thanks: 0
Thanked 130 Times in 130 Posts
June7 will become famous soon enough
Re: Custom Ribbons - Show/Hide groups

It is possible to dynamically change ribbon without closing db. That's what the RibbonName property of form and report is for.

__________________
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
June7 is offline   Reply With Quote
Old 09-15-2018, 06:58 PM   #4
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,547
Thanks: 55
Thanked 2,084 Times in 1,996 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Custom Ribbons - Show/Hide groups

i put 2 global var in basGlobal.
see the code in getVisible sub that uses these var.
when the rivbon is loaded i open the ligin form.
in actual yoi will use textbox for input in login and not combo.
Attached Files
File Type: zip Employees.zip (61.9 KB, 3 views)

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Reply

Tags
customized ribbon , ribbon , ribbons , vba access 2016

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Ribbons ryetee General 12 03-28-2018 01:43 PM
Custom Ribbons Acropolis Modules & VBA 3 07-27-2017 02:59 AM
Custom Ribbons chrisguk General 1 05-24-2011 11:19 AM
Custom Ribbons Joshann Modules & VBA 7 04-08-2010 10:45 AM
Using option groups to show/hide subforms kitsune182 Modules & VBA 2 06-18-2009 12:01 PM




All times are GMT -8. The time now is 07:03 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World