Custom Ribbons

[ryetee]

I want to use some custom ribbons in Access 2016.

I think I'm getting to grips with it but...there's always a but.

I want most forms to have the same custom ribbon. So I've set up in file options current database the default ribbon name in Ribbon and Toolbar options.

There are some forms that I want to use another ribbon and there is an option in the form controls under other for this. i.e Ribbon name.

I've tested this by open and closing forms and all seems to be fine.

The problem arises when I try to load my first form automatically either through autoexec, or specifying it in the display form options in form options current database. This first form uses a different ribbon which isn't being picked up in these circumstances. If I get rid of the automatic load and run it myself it works a treat.

Any ideas?

 

[MarkK]

This first form uses a different ribbon which isn't being picked up in these circumstances.

How exactly is this ribbon set? Has the RibbonName property of this form been set in design view, or does this occur programmatically when the form opens? If the latter, is there a problem with the code that sets this property?

How are your ribbons defined? Do you have a USysRibbons table? If not, are you certain that your execution of LoadCustomUI occurs before this form opens?

hth
Mark

 

[ryetee]

How exactly is this ribbon set? Has the RibbonName property of this form been set in design view, or does this occur programmatically when the form opens? If the latter, is there a problem with the code that sets this property?

How are your ribbons defined? Do you have a USysRibbons table? If not, are you certain that your execution of LoadCustomUI occurs before this form opens?

hth
Mark

OK I'm using UsysRibbons with a variety of differing ribbons.
The RibbonName of the first form to be loaded is set in design view.

 

[MarkK]

Well, I can't think of any other things to check. Can you post a db that demonstrates the problem?
Mark

 

[isladogs]

As Mark indicated, it should work.
You haven't said whether its loading the other default ribbon for the startup form

As an experiment, try changing the default ribbon to the one used in the startup form & setting the current default using code for the other forms. Does that work?

 

[ryetee]

Well, I can't think of any other things to check. Can you post a db that demonstrates the problem?
Mark

I will do when I get a chance

 

[ryetee]

As Mark indicated, it should work.
You haven't said whether its loading the other default ribbon for the startup form

As an experiment, try changing the default ribbon to the one used in the startup form & setting the current default using code for the other forms. Does that work?

Yes it does load the default one (from file options, etc etc). I'll give that a whirl - so basically as it stands now I have the default ribbon for 99% of the forms and the one I load first (should) pulls in it's Own ribbon. You're saying have the default set to the 1% and all other forms pull in the other ribbon.

 

[isladogs]

Purely as an experiment .... and only because the sensible route isn't working.

Try altering a couple of the 99% first rather than all of them. It may not work

 

[ryetee]

Purely as an experiment .... and only because the sensible route isn't working.

Try altering a couple of the 99% first rather than all of them. It may not work

Yes that works but I've taken my eye off the ball here. I have to have it the other way round.

The form that is loaded is the login form (user and password). The idea is that when filled in this form is then closed leaving a blank screen and the default ribbon. Selecting something from the ribbon will then open the approprate form.


I have got around the problem by having each form check to see if the user has logged in (user name held in a public variable) and if not closing the current form and opening the login form first which now loads the default ribbon for the login form. After entering details the original form is then opened again and the default ribbon displayed.

Hope this makes sense.

 

[isladogs]

Yes that works but I've taken my eye off the ball here. I have to have it the other way round.

The form that is loaded is the login form (user and password). The idea is that when filled in this form is then closed leaving a blank screen and the default ribbon. Selecting something from the ribbon will then open the approprate form.


I have got around the problem by having each form check to see if the user has logged in (user name held in a public variable) and if not closing the current form and opening the login form first which now loads the default ribbon for the login form. After entering details the original form is then opened again and the default ribbon displayed.

Hope this makes sense.

That sounds convoluted

Several thoughts here
1. Why do you need a ribbon on a login form? Suggest removing it here
2, Normally when users login to a database, a specific form should open.
If instead you want a choice of say 6 different forms, open a form with 6 buttons each of which will open a specific form
If that will work for you, it seems to me that no ribbon is needed here either....

 

[ryetee]

That sounds convoluted

Several thoughts here
1. Why do you need a ribbon on a login form? Suggest removing it here
2, Normally when users login to a database, a specific form should open.
If instead you want a choice of say 6 different forms, open a form with 6 buttons each of which will open a specific form
If that will work for you, it seems to me that no ribbon is needed here either....

1. The ribbon isn't on the login form. In fact I'm trying to get rid of anything on the login screen including File
2. The user has an existing systems that has tabs at the top. When he clicks a tab he gets a sub menu which he then selects an item that will display a form. In much the same way you can say click on Edit in MS Word and get a load of options. After a load of research I couldn't see how to do it - I think I posted something on here and got nowhere. The nearest I could come up with is using ribbons.
If you have a better idea then let me know as I'm about to get to a point of no return!

 

[isladogs]

See attached short video showing the startup process for one of my apps
a) splash form floating on desktop running checks
b) login form - the admin button is hidden to end users
NOTE - no ribbon displayed
c) after logging in, main form opens with a range of possible choices
Not all buttons are visible to all users - which are shown depends on user permissions according to loginID.
Only program admins get the menu bar & ribbons

HTH

 

[ryetee]

See attached short video showing the startup process for one of my apps
a) splash form floating on desktop running checks
b) login form - the admin button is hidden to end users
NOTE - no ribbon displayed
c) after logging in, main form opens with a range of possible choices
Not all buttons are visible to all users - which are shown depends on user permissions according to loginID.
Only program admins get the menu bar & ribbons

HTH

I have built systems like this before but this user wants a look that he's familiar withhence the ribbon. AlsoI don't want him to be able to use any of the access menus themselves