Stop Form Jumping on Startup

[map@freeola.net]

Hi

Perhaps I'm a perfectionist but an application that I have does not display the ribbon bar, status bar, navigation etc. just the form on startup form.

It seems that the deletion of the bars does not take effect until after the form loads so it jumps ( AND I DON'T THINK THAT LOOKS RIGHT!)

Any thoughts on how to effect the actions before the form loads?

Thanks

Michael

Have example accdb but it will not let me upload

 

[boblarson]

How are you removing the Ribbon/Status Bar, etc.? (I can't download and look because I don't currently have a way to open accdb files at work as they took the computer that had Access 2007 on it away for some new person to use )

 

[map@freeola.net]

Hi Bob

Attached mdb file.

Welcome your comments.

Michael

 

[boblarson]

Create a public function in a standard module to do the hiding (removing it from the form's On Load event) and then call it using a macro using the Action RUN CODE and then the function name (it has to be a function and not a sub).

Then save the macro as the name AutoExec.

 

[map@freeola.net]

Hi Bob

Thanks for the thought.

Tried that but the function code does not go into effect until a form loads and the jump as it looses the ribbon bar.

Have you used:

Office Button > Access Options > Current Database > Navigation.

It seems that a new ribbon can be created to load but can it also be used to switch off ribbons.

Any knowledge of this route?

Thanks Michael

 

[boblarson]

Hi Bob

Thanks for the thought.

Tried that but the function code does not go into effect until a form loads and the jump as it looses the ribbon bar.

Have you used:

Office Button > Access Options > Current Database > Navigation.

It seems that a new ribbon can be created to load but can it also be used to switch off ribbons.

Any knowledge of this route?

Thanks Michael

It is obvious, in my view, that you have not tried what I said. An AutoExec macros will run BEFORE ANYTHING ELSE IN THE DATABASE. It will run before references are checked, before table links are checked, before anything is loaded - ANYTHING. So, what is it that you actually tried to do?

 

[boblarson]

Okay, I just was able to get out my netbook and try it all out using Access 2010. The issue is that the Ribbon will be there as the database opens and then it turns off the toolbar. There is nothing that can be done with that. It is part of the interface of the application. Even if you provide your own there will still be a Ribbon there as the Application opens.

So, sorry about the terse message before. The code is working fine but it just looks like it is jumping because the Ribbon is going away.

 

[boblarson]

I just tested with adding my own Ribbon with the startFromScratch and nothing else and it still appeared to jump because the interface showed the ribbon briefly when opening the database from the Windows Explorer even.

 

[map@freeola.net]

Hi Bob

Thanks for you input.

Looks like I have to put up with a jump unless microsoft make a change.

With Access 2000 you could replace the men bar with a blank bar so you didn't get a jump.

Could the ribbon be replaced with a blank ribbon and stop the jump.

thanks Michael

 

[boblarson]

Hi Bob

Thanks for you input.

Looks like I have to put up with a jump unless microsoft make a change.

With Access 2000 you could replace the men bar with a blank bar so you didn't get a jump.

Could the ribbon be replaced with a blank ribbon and stop the jump.

thanks Michael

Yeah, you could create your own and populate it with something - an existing group or a custom group with existing buttons or your own.

 

[phatus]

sir bob can you make a sample of it? im not good in coding.. i've been searching on it in the internet but i cant understand it...

 

[map@freeola.net]

Hi Bob

Really appreciate your advice and it looks like a blank ribbon and QAT seems the only way.
As coming from Access 2000 I have no knowledge of ribbons or QAT.
Can you direct me to where I can learn how to:
1. Create blank ribbon and QAT.
2. Insert blank ribbon and delete/hide other ribbons inc File and QAT.
3. Anything else I should do?
Many thanks
Michael (UK)

 

[boblarson]

Here's a good tutorial:

http://www.access-freak.com/tutorials.html#Tutorial05

 

[map@freeola.net]

Hi Bob
FOUND A SOLUTION!!!!!
Followed your link thanks.
Found another site on ribbons: accessribbon.de/en/[/url]
Has some downloadable demos and they did not JUMP.

Found reason 1ST FORM MUST BE POP UP and they do no jump on hiding ribbons.
Great and it looks better as 1st form.

Many thanks for your help and direction.
Michael