Recovering Closed Custom ToolBar

[David G. Harris]

I have developed an Access 2000 aplication which includes a customised
toolbar (Menu). The application has been compiled into an .MDE file and is
installed on 4 workatations using the Access 2000 Runtime with the data .MDB
located on a Server. The application runs without problem except that 2 of
the users have somehow closed or disbaled the Custom ToolBar (Menu). Is
there a way to turn the ToolBar (Menu) back on in the runtime, I have been
unable to find a way to restore this ToolBar (Menu), I have re-installed the
application MDE file from my original distribution CD, I have run both repair
options (Repair & Replace) in the Access 2000 Runtime without any success, I
have also tried recompiling the MDE & re-installing but the ToolBar(Menu) is
still missing. How can I resolve this problem, is there a way? Please Help
as my client's users are unable to access uch of the functionality of my
application. Please Help?

 

[Rick Brandt]

I have developed an Access 2000 aplication which includes a customised
toolbar (Menu). The application has been compiled into an .MDE file
and is installed on 4 workatations using the Access 2000 Runtime with
the data .MDB located on a Server. The application runs without
problem except that 2 of the users have somehow closed or disbaled
the Custom ToolBar (Menu). Is there a way to turn the ToolBar (Menu)
back on in the runtime, I have been unable to find a way to restore
this ToolBar (Menu), I have re-installed the application MDE file
from my original distribution CD, I have run both repair options
(Repair & Replace) in the Access 2000 Runtime without any success, I
have also tried recompiling the MDE & re-installing but the
ToolBar(Menu) is still missing. How can I resolve this problem, is
there a way? Please Help as my client's users are unable to access
uch of the functionality of my application. Please Help?

I have the same problem. My last distribution made sure that the Toolbar
was docked and that all properties were set to disallow any changes to
docking, moving, or showing/hiding and I STILL have one user that somehow
managed to get the toolbar undocked and now can't redock it because of the
property settings.

That last revision also added....

DoCmd.ShowToolbar "MyToolBar", acToolbarYes

....to the Start-Up routine so at least I don't have the problem of the
toolbar not showing up at all.

This data is stored in the registry, but it is not user editable. The
following "might" work.

Find the registry setting in the appropriate branch for your version of
Access for the particular ToolBar and delete it. For me that is...

[HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings\CommandBars
]

That branch will have a key for each toolbar and/or menu that has ever been
moved or docked. If you replace the file with a new copy after the key has
been deleted the toolbar might end up back where it belongs. (I'm still
testing stuff on this issue so I can't be more sure than this).

 

[David G. Harris]

Thanks for the suggestion, I will investigate & experiment further using one
of my own computers on which I have the Access 2000 Runtime installed. I was
rather hoping there might have been an easier solution that didn't involve
changing Operating System Registry Entries? Is there any way of being able
to re-activate a ToolBar (Menu) from within the Runtime?

I have developed an Access 2000 aplication which includes a customised
toolbar (Menu). The application has been compiled into an .MDE file
and is installed on 4 workatations using the Access 2000 Runtime with
the data .MDB located on a Server. The application runs without
problem except that 2 of the users have somehow closed or disbaled
the Custom ToolBar (Menu). Is there a way to turn the ToolBar (Menu)
back on in the runtime, I have been unable to find a way to restore
this ToolBar (Menu), I have re-installed the application MDE file
from my original distribution CD, I have run both repair options
(Repair & Replace) in the Access 2000 Runtime without any success, I
have also tried recompiling the MDE & re-installing but the
ToolBar(Menu) is still missing. How can I resolve this problem, is
there a way? Please Help as my client's users are unable to access
uch of the functionality of my application. Please Help?

I have the same problem. My last distribution made sure that the Toolbar
was docked and that all properties were set to disallow any changes to
docking, moving, or showing/hiding and I STILL have one user that somehow
managed to get the toolbar undocked and now can't redock it because of the
property settings.

That last revision also added....

DoCmd.ShowToolbar "MyToolBar", acToolbarYes

....to the Start-Up routine so at least I don't have the problem of the
toolbar not showing up at all.

This data is stored in the registry, but it is not user editable. The
following "might" work.

Find the registry setting in the appropriate branch for your version of
Access for the particular ToolBar and delete it. For me that is...

[HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings\CommandBars
]

That branch will have a key for each toolbar and/or menu that has ever been
moved or docked. If you replace the file with a new copy after the key has
been deleted the toolbar might end up back where it belongs. (I'm still
testing stuff on this issue so I can't be more sure than this).

 

[Rick Brandt]

Thanks for the suggestion, I will investigate & experiment further
using one of my own computers on which I have the Access 2000 Runtime
installed. I was rather hoping there might have been an easier
solution that didn't involve changing Operating System Registry
Entries? Is there any way of being able to re-activate a ToolBar
(Menu) from within the Runtime?

As I said, you can give him a new file that automatically runs code to show the
ToolBar at startup, but you won't be able to control its position or docking
status (at least I don't know how to do that yet).