Ribbon before AutoExec

[arnelgp]

do you have loadimage on the ribbon

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="OnRibbonLoad" loadImage="LoadImages">

 

[smig]

do you have loadimage on the ribbon

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="OnRibbonLoad" loadImage="LoadImages">

No
What does it do ?

 

[isladogs]

1. yes, the Ribbon is in the Access' options
2. How can I open this form with no AutoExec macro?

2. Set the startup form in Access options!

 

[arnelgp]

as it connotes it Loads the Image of the ribbon.

 

[smig]

2. Set the startup form in Access options!

Not working for me
will not load the ribbon if there is a MsgBox in code

 

[smig]

as it connotes it Loads the Image of the ribbon.

Why do I need to load an image ?

I tried to put this, but it's not working

loadImage = "fnAutoExec">

 

[isladogs]

Not working for me
will not load the ribbon if there is a MsgBox in code

I sense we're going round in circles....see post #15
Anything involving user interaction such as a message box will prevent the code completing

EDIT:
In addition, arnel seems to be suggesting a totally different approach.
Don't try & do both in the same app

 

[deletedT]

How about uploading a simplified version of your database and let others try it?

 

[smig]

As suggested By Tara I uploaded a test version of this AutoExec issue

I hope we can find a working solution to load the Ribbon before AutoExec stop

Thank you all for your time

 

[isladogs]

Attached is a quick and simple example using your ribbon and the approach I suggested way back in post #15. I assume you didn't actually try that method!

I've used a new startup form frmStart with a timer event that triggers a message after 1 second.
I've renamed your autoexec macro to disable it.

I recommend you either run all your checks from the startup form or use an autoexec just for code which doesn't require user interaction. If you do decide to use autoexec, a submacro isn't necessary

The attached works. The modified ribbon appears before the form loads then the message shortly after. It can be improved further but hopefully you get the point

 

[smig]

Attached is a quick and simple example using your ribbon and the approach I suggested way back in post #15. I assume you didn't actually try that method!

I've used a new startup form frmStart with a timer event that triggers a message after 1 second.
I've renamed your autoexec macro to disable it.

I recommend you either run all your checks from the startup form or use an autoexec just for code which doesn't require user interaction. If you do decide to use autoexec, a submacro isn't necessary

The attached works. The modified ribbon appears before the form loads then the message shortly after. It can be improved further but hopefully you get the point

I did try your suggestion.
Now I see you put the code into the Form_Timer() event and not into the OnLoad() event

This seems to work very well

Thanks a lot

 

[isladogs]

I did try your suggestion.
Now I see you put the code into the Form_Timer() event and not into the OnLoad() event

This seems to work very well

Thanks a lot

Hooray. Glad you now see what I meant.
I've used that method for years and knew it worked.
I think you may have been getting too many different bits of advice at once

 

[arnelgp]

without hidden form it works for me.

 

[isladogs]

without hidden form it works for me.

Without the BE file it doesn't load properly....
To me it does seem a bit like using a sledgehammer to crack a nut

 

[smig]

without hidden form it works for me.

I saw it load the FrontPage form and the Ribbon from the App Access' options
Where is the StartUp/AutoExec routines ?

 

[smig]

Without the BE file it doesn't load properly....
To me it does seem a bit like using a sledgehammer to crack a nut

Is there any way to hide or minimize the form?
I tried using me.visible = false in the OnLoad and in the OnOpen event with no luck

 

[isladogs]

Smig
You've quoted me but I was referring to arnel's uploaded file.
Which of us is this addressed to?

In case you meant my version, attached is a modified version where the start form is hidden.
You do this by opening the form hidden from an autoexec macro. Also remove it as the startup form in Access options.

Obviously you would need to add code to that form to then open the main form / login form when all your code checks have run

 

[smig]

Smig
You've quoted me but I was referring to arnel's uploaded file.
Which of us is this addressed to?

Ooops, Sorry, it was addressed to you

Is there any way to hide or minimize the StartUp form?
I tried using me.visible = false both in the OnLoad and in the OnOpen event with no luck

 

[isladogs]

Posts crossed. Added extra info / example

 

[smig]

Posts crossed. Added extra info / example

What does it mean ?