By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Disable Add or Remove Buttons selector

P: 3
I have an application in Access 2003 OS XP Professional that I need to implement in my organization, has been received from another division of ours. When opened the form frmmain opens that has some buttons controlling the further flow. As the form toolbar is displayed it allows user access to the Database Window and New Object icons, which I do not want to happen in order to avoid unnecessary access to tables and structure.
By clicking on the Add or Remove Buttons selector I unchecked all icons to avoid user access, but then the user could check them back. My question is there any way to programatically disable the Add or Remove Button selector for the form toolbar?
Mar 12 '07 #1
Share this Question
Share on Google+
9 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I have an application in Access 2003 OS XP Professional that I need to implement in my organization, has been received from another division of ours. When opened the form frmmain opens that has some buttons controlling the further flow. As the form toolbar is displayed it allows user access to the Database Window and New Object icons, which I do not want to happen in order to avoid unnecessary access to tables and structure.
By clicking on the Add or Remove Buttons selector I unchecked all icons to avoid user access, but then the user could check them back. My question is there any way to programatically disable the Add or Remove Button selector for the form toolbar?
You can create custom menus and toolbars or just disable the toolbars altogether using the startup options.
Mar 13 '07 #2

ADezii
Expert 5K+
P: 8,619
I have an application in Access 2003 OS XP Professional that I need to implement in my organization, has been received from another division of ours. When opened the form frmmain opens that has some buttons controlling the further flow. As the form toolbar is displayed it allows user access to the Database Window and New Object icons, which I do not want to happen in order to avoid unnecessary access to tables and structure.
By clicking on the Add or Remove Buttons selector I unchecked all icons to avoid user access, but then the user could check them back. My question is there any way to programatically disable the Add or Remove Button selector for the form toolbar?
By utilizing the CommandBars Collection, a shared Office Component, you are limitless as to what you can do with Menu Bars and Toolbars. Be advised, it is a complex and confusing area. If you do decide to naigate these waters, you must set a Reference to the Microsoft Office Object Library. Good luck.
Mar 13 '07 #3

P: 3
By utilizing the CommandBars Collection, a shared Office Component, you are limitless as to what you can do with Menu Bars and Toolbars. Be advised, it is a complex and confusing area. If you do decide to naigate these waters, you must set a Reference to the Microsoft Office Object Library. Good luck.
Could you suggest some source to review the objects name/properties/methods for Menu Bars and Toolbars for the Access program?
Mar 13 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
Could you suggest some source to review the objects name/properties/methods for Menu Bars and Toolbars for the Access program?
The Access help file should help.
Mar 13 '07 #5

ADezii
Expert 5K+
P: 8,619
Could you suggest some source to review the objects name/properties/methods for Menu Bars and Toolbars for the Access program?
From the VBA IDE, reference Help ==> CommandBars Collection Object
Mar 13 '07 #6

NeoPa
Expert Mod 15k+
P: 31,342
You can create custom menus and toolbars or just disable the toolbars altogether using the startup options.
Did you find the StartUp options were inadequate for purpose then? Or perhaps you skipped too quickly past this post?
ADezii can take you through some very powerful stuff, but it won't be as easy as fiddling in the StartUp options.
Mar 13 '07 #7

ADezii
Expert 5K+
P: 8,619
From the VBA IDE, reference Help ==> CommandBars Collection Object
Here is a little code snippet that I am reluctant to show you, because once code like this is executed, it modifies the Registry and the setting persists unless otherwise Reset. e.g. The following line of code will disable the Database Window (F11) Icon on the Form Toolbar and it will remain Disabled until it is changed again. Be careful when experimenting with these settings.
Expand|Select|Wrap|Line Numbers
  1. Application.CommandBars("Form View").Controls("Database Window").Enabled = False
Mar 13 '07 #8

P: 3
Here is a little code snippet that I am reluctant to show you, because once code like this is executed, it modifies the Registry and the setting persists unless otherwise Reset. e.g. The following line of code will disable the Database Window (F11) Icon on the Form Toolbar and it will remain Disabled until it is changed again. Be careful when experimenting with these settings.
Expand|Select|Wrap|Line Numbers
  1. Application.CommandBars("Form View").Controls("Database Window").Enabled = False
Very concise and to the point 'how to do' suggestions. Need some time out to reflect and start experimenting step by step. Thanks a lot to all.
Mar 14 '07 #9

ADezii
Expert 5K+
P: 8,619
Very concise and to the point 'how to do' suggestions. Need some time out to reflect and start experimenting step by step. Thanks a lot to all.
We were all glad to help.
Mar 14 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.