Menubar loses position

[Mark]

I have a access project and have created a customized menubar. I have turned
off the main "menubar". I have noticed this on other machines and just
recently on mine. When I open the project, the toolbar has moved from the
top of the screen to the middle of the form. I can drag it back to the top,
close the app and restart and the toolbar shows up in the middle of the form.
It has been working correctly on my machine for weeks (Showing up at the top
of the screen).

Any suggestions???

 

['69 Camaro]

Hi, Mark.

When I open the project, the toolbar has moved from the
top of the screen to the middle of the form. I can drag it back to the top,
close the app and restart and the toolbar shows up in the middle of the form.

Are you sharing this database file with other users, perchance? (The
database should be split, with each user having a copy of the front end on
his own workstation, and the back end residing on the networked file server.
Users usually shouldn't need to open the back end, but it occasionally
happens.) It sounds like you are getting someone else's setting, because he
doesn't like your setting and just changes it.

First, place the toolbar where you want it on the screen. Next, right-click
on the toolbar and select Customize... from the pop-up menu to open the
Customize dialog window. Select the Toolbars tab and scroll down until you
see the name of your custom toolbar. Select the name of your toolbar, then
select the "Properties" button to open the Toolbar Properties dialog window.

In the "Docking" combo box, change "Allow Any" to "Can't Change." Uncheck
the "Allow Moving" check box. Select the "Close" button to close the Toolbar
Properties dialog window. Select the "Close" button to close the Customize
dialog window.

Now it's stuck where you put it. If you find that this toolbar is ever
moved when you open it in the future, try to determine who in your
organization has sufficient knowledge of Access to know where to alter this
setting as you just did. If, instead, you receive a phone call or E-mail
from one of the users complaining that he can't move this custom toolbar,
you've found your habitual offender, because he turned himself in. ;-)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[Mark]

Thanks for responding to my question. Actually no one else is using this
copy. I am in the developing stages and I keep this version on my client
box. After I make significant changes I create a run-time version. This is
how I know that no one else could make this change. I have attempted to use
the customized settings to no avail. For instance, I open the project, the
menubar is in the middle of the page. I move it to the top and then change
the settings to can't move and then close the project and then reopen it.
The menubar is back to the middle of the page.

 

['69 Camaro]

Hi, Mark.

I have attempted to use
the customized settings to no avail. For instance, I open the project, the
menubar is in the middle of the page.

The settings you make are saved in a Windows Registry key. Perhaps you
don't have Windows security permissions to write to this key on your
workstation? Perhaps the key is corrupted. The default Windows Registry
location for the custom CommandBars is:

HKEY_CURRENT_USER\Software\Microsoft\Office\<version#>\Access\Settings\CommandBars

The key value is named "ACB" followed by the name of your toolbar. The
value is binary, so you shouldn't attempt to alter it manually.

I've never tried this myself, but I suspect that you could copy the binary
value in a separate file, then make your changes in your Access database,
then compare the new value in the key to the old value you saved in the
separate file. If they are the same, then your changes were definitely not
saved to the Windows Registry and you need to determine why.

Good luck.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[Mark]

Thanks again. I will try your suggestions Monday. I actually read another
discussion group who suggested to delete the registry key. I tried this and
then made my changes and opened it back up. I still had the same problem. I
did not try to compare the values.

Thanks again

 

[Mark]

'69

I tried to make some changes to the regedit to no avail. One thing that I
noticed was that if I opened Microsoft Access the main toolbar was also in
the middle of the page. I moved it back up top, reopened my application and
voila. My toolbar is back on top. I guess there is some kind of default
built-in to read access's placement.
Is there any way to programmatically make the menubar's position at the top
of the page?

Thanks,

 

['69 Camaro]

Hi, Mark.

I moved it back up top, reopened my application and
voila. My toolbar is back on top. I guess there is some kind of default
built-in to read access's placement.

Your custom toolbar's default position is set relative to the built-in
toolbar whenever it's not a standalone toolbar. When the built-in toolbar is
absent, I would think that the custom toolbar would be where you last placed
it, but apparently this is not the case when the built-in toolbar is moved to
some place other than the top of the screen prior to being turned off.

Is there any way to programmatically make the menubar's position at the top
of the page?

Perhaps. You might try this untested code:

' NOTE: Set a reference to your version of the
' Microsoft Office Object Library so that you can
' use the CommandBar and CommandBars objects.

Dim CmdBar As CommandBar

Set CmdBar = CommandBars("MyCommandBarName")
CmdBar.Position = msoBarTop

.... where MyCommandBarName is the name of your custom CommandBar.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.