Disable a Custom Menu/Toolbar

[gblack301]

Hi,
I have inherited a database that I am working with in Access 2003 but the client is utlizing/working with same database in Access 2007. My predecessor built this database using a custom menu/toolbar preventing any access to the form design toolbar. Is there any clear-cut method to bypass this menu and open the database with the standard menu and toolbars?

In addition, I have not found any admin module/version for this database and he is not using any type of user level security. Any suggestion would be appreciated. Thanks in advance.

Kindest Regards,
Greg

[MindBender77]

Hi,
I have inherited a database that I am working with in Access 2003 but the client is utlizing/working with same database in Access 2007. My predecessor built this database using a custom menu/toolbar preventing any access to the form design toolbar. Is there any clear-cut method to bypass this menu and open the database with the standard menu and toolbars?

In addition, I have not found any admin module/version for this database and he is not using any type of user level security. Any suggestion would be appreciated. Thanks in advance.

Kindest Regards,
Greg

Assuming the shift key isn't disabled, you could hold down shift and double click on the database. This will show you the data base window and temporarily disable the custom toolbar.

Next, under Tools, select Startup.... and change the Menu Bar to default.

Hope this helps or atleasts leads you in the right direction,
JS

[gblack301]

Assuming the shift key isn't disabled, you could hold down shift and double click on the database. This will show you the data base window and temporarily disable the custom toolbar.

Next, under Tools, select Startup.... and change the Menu Bar to default.

Hope this helps or atleasts leads you in the right direction,
JS

Hey JS,
Thanks for quick response, I actually tried holding down the shift-key before and opening the database but it didn't work.

Is there any other method to disable this custom toolbar? Thanks again for any input.

Kindest Regards,
Greg

[MindBender77]

Hey JS,
Thanks for quick response, I actually tried holding down the shift-key before and opening the database but it didn't work.

Is there any other method to disable this custom toolbar? Thanks again for any input.

Kindest Regards,
Greg

I've been racking my brain on this for a bit and trying to duplicate your problem. I have found a way to active the default command bar however, you can let the database initialize normally, then hit Shift F11. This will bring up the database window. From this point you can right click on the form/report and select design view.

This still might not work because the shift key might be disabled but, its worth a try at least. Another key combination you could try is ALT+F11 which will bring up the VBA in the database.

I'll keep searching and try to find you/us a solution,
JS

[ADezii]

Hi,
I have inherited a database that I am working with in Access 2003 but the client is utlizing/working with same database in Access 2007. My predecessor built this database using a custom menu/toolbar preventing any access to the form design toolbar. Is there any clear-cut method to bypass this menu and open the database with the standard menu and toolbars?

In addition, I have not found any admin module/version for this database and he is not using any type of user level security. Any suggestion would be appreciated. Thanks in advance.

Kindest Regards,
Greg

Assuming that your Custom Toolbar is specifically assigned to your Form's Toolbar Property, you can Reset the Toolbar Property for the Form to an empty String, in which case Access will load the built-in Toolbar for the Form as in:

'The Built-in Toolbar for frmTest will be loaded instead of the Customized one.
Forms.Item("frmTest").Toolbar = ""

[gblack301]

I really appreciate all of the help. I opened the database and used the F11 option(s) and it worked. Once again, thank you very much!

Kindest Regards,
Greg

[MindBender77]

Assuming that your Custom Toolbar is specifically assigned to your Form's Toolbar Property, you can Reset the Toolbar Property for the Form to an empty String, in which case Access will load the built-in Toolbar for the Form as in:

'The Built-in Toolbar for frmTest will be loaded instead of the Customized one.
Forms.Item("frmTest").Toolbar = ""

Just a thought, Adezii, being it's on the same topic and could assist others.

Could you also use the "CommandBars" method as well? I got close to the target result but, not quite.

Example:

CommandBars("Menu Bar").Enabled = False
 

JS

[ADezii]

Just a thought, Adezii, being it's on the same topic and could assist others.

Could you also use the "CommandBars" method as well? I got close to the target result but, not quite.

Example:

CommandBars("Menu Bar").Enabled = False
 

JS

Yes, through the CommandBars Collection you have access to the complete functionality of Menu Bars and Toolbars. For instance, the following line of code will disable the 1st Control on the Custom 1 Toolbar:

Application.CommandBars("Custom 1").Controls(1).Enabled = False