Disable Menu-Command Option
Apr 25, 2005With this
Me.Application.CommandBars("Menu Bar").Controls("&File").Enabled = False
I can disable the Command "&File" in the Menu bar, How can i disable its menu option Like "Print Preview"
ADVERTISEMENT
Disable Menu Paste Option In Combo Box
Oct 18, 2006I'm trying to disable users from right clicking, from within a combo box and selecting paste. The following code is suppose to work
Private Sub DESCREP_DESCRIPTION_GotFocus()
Application.CommandBars("Form View Control").Controls("Paste").Enabled = False
End Sub
but it doesn't work, any suggestions?
Mde - Disable Menu Options
Apr 20, 2006I'd like to disable the options to see the table or query design - and control other thing the user can or can't see.
How can I do that?
Disable Restore Button On Menu Bar
Jul 23, 2005Is it possible to disable the Restore button that's displayed on the menu bar when a form is maximised?
View 2 Replies View RelatedGeneral :: How To Disable Menu Choice
Jun 16, 2014I have several menus defined for Access 2010. However, only one is set with the visible property set to true.The user is able to show and bring up the other menus by right-clicking in the menu area. How can I disable this so the user may not bring up these menus? An example is shown in the picture below. I don't want to give the user access to the "CPLAccess" and "Datasheet column removed" menus, but I do want to keep them so that I can make them visible via VBA.
View 8 Replies View RelatedDisable Tool-Bar Menu - 'Delete Record'
Apr 20, 2006Hello Everyone,
Before I pose my question I would first like to applaud and thank this forum for the excellent and timely help it has provided me so far. The assistance I have received to date, from you as members, and via the search facility has been extremely helpful particularly as I am new to this type of stuff…
My question is this...
I would like to disable users from selecting the 'Edit - Delete Record' facility from my main form upon its load. From searching the various forums I found a method upon which to disable the whole 'Edit' menu but not the specific 'Delete Record' function. Please accept my sincere apologies if this has already been posted but I simply cannot find it readily via a standard/refined 'search'. It might be the fact that I am phrasing the question incorrectly?? I don't want to severely restrict my users by disabling/hiding the whole menu but would rather limit them to accessing this option via a password protected command button?
What I have found so far.
Private Sub Form_Load()
CommandBars("Menu Bar").Controls("Edit").Visible = False
End Sub
Any assistance/guidance would be very much appreciated
Kind Regards – Best wishes to all of the registered site members
CarolW
:)
Disable All Menu Bars Except The Right Click Mouse
May 1, 2006Hi,
For i = 1 To CommandBars.count
If (CommandBars(i).name <> "Right Click Mouse") Then
CommandBars(i).Enabled = False
End If
Next i
I tried to use this code.
However, right click mouse is disable.
How can I disable all menus except the right click mouse option?
Thanks.
Clearing Buttons From An Option Box Menu
Jun 20, 2006I have a switchboard which gives two selections. Upon selecting a menu item, the new menu appears. If I select from this new menu, it runs as it should do. However, upon returning to this second menu, the button remembers where it was instead of being cleared to select the same item, if desired, again. How can the option box button be cleared as do the switchboard buttons?
View 1 Replies View RelatedDisable File-->Print Option
Dec 12, 2006I have a Print button on a form, which actually prints off a report for the user.
Some of them seem to be trying File-->Print, which actually just prints the form instead of the report and no matter how many times I've told them to use the Print button, they seem incapable of remembering.
Is there a way to turn off the File-->Print option ?
Disable / Option Group After Update
May 28, 2005Hi,
Newbie needing a shove in the right direction. My option group will be confusing for a user because it defaults to the Male selection
of the Male / Female option. In other words, as the user views the form to scroll through the records, the option button will always be at the Male selection, regardless of what was originally selected to update the table field. Is it possible to hide the option group once it has been used to input that record, or, have it display the correct selection for that particular record?
General :: Disable SharePoint Access Setting Option For Certain User
Oct 3, 2014I just published an access database to sharepoint. However, after I set some user as contributor, those users can see structure of my database, and export tables to excel directly. Is there anyway that we can remove the access to "Setting"?
View 2 Replies View RelatedGeneral :: How To Disable / Prevent Overwrite Option In Window From Being Selected
Sep 8, 2013Creating a database for processing survey data into a report format. We receive these reports as paper copies, which are then scanned in using Remark Office OMR. This results in a table of data, which is intended to be appended to the existing table in the database using Save As --> Access 2007, selecting the database and target table, clicking save as, and then selecting 'Append' from the subsequent popup.
What I want to know is: Is it possible to disable/otherwise prevent the 'Overwrite' option in this window from being selected? Can I make the table or database in such a way that data can only be added, not edited or deleted?
Disable Command Button
May 8, 2007I have a command button which will work on a specified date of every year. After the user clicks it once (which will carry out calculations), I want this button to be disabled so that it is not available for second click. Is it possible?
View 1 Replies View RelatedLaunching Menu Command From Code
May 12, 2007Hello.
Your help is very much appreciated.
I want to launch the "partial replica wizard" from code.
Can it be done?
(It is located in Tools -> Replication ->partial replica wizard
Thank you.
Cheers
Roy
Accessing Filter Menu With Command Button
Dec 26, 2013How could I activate filter menu with a command button. The filter menu I am referring to is the one on the home tab.
View 1 Replies View RelatedGeneral :: Command Button Enable Or Disable
Jul 27, 2012I have a form. and it has three buttons. Such as Submit, Reject, Under Observation.
I want :
1) If i click SUBMIT button it will be disable and other two buttons REJECT and UNDER OBSERVATION will be enable
2) If i click REJECT button it will be disable and other two buttons SUBMIT and UNDER OBSERVATION will be enable
3) If i click UNDER OBSERVATION button it will be disable and other two buttons SUBMIT and REJECT will be enable
Enable / Disable Command Button After Conditions Have Been Met
Mar 9, 2012Objective: After each field in my form is completed, I want my NewSave button to be enabled.
Problem: Created an if/then code that disables the button but never re enables it after conditions are met
Code:
Private Sub Form_Current()
Dim promptmsg As LongÂ
If IsNull(Me.ContractValue) = False And IsNull(Me.ContractNumber) = FalseÂ
And IsNull(Me.InvoiceDate) = False  Then Me!NewSave_Button.Enable = True Â
[Code] .....
Modules & VBA :: Right Click Menu Command Bar Index Number?
Aug 13, 2014I have a form that i used the following code on to stop people accessing anything naughty:
Code:
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
This works great and gets rid of all the menu bars.
The problem is that it also stops the user getting the right click menu up in a datasheet view.
I assume i just need to enable the correct menu bar index number but i don't know what it is so my code would be:
Code:
CommandBars(X).Enabled = True
So do I need to bring back more than one command bar to get it working?
Forms :: Disable A Command Button Until Field Is Populated
Sep 17, 2014I am going round in circles here; I have a form which has certain text fields that need to be populated before a user can click a command button named 'Record Movement' that opens up another form. What I want to do is disable the 'Record Movement' button until these fields are populated. I am using Access 2010.
View 6 Replies View RelatedQueries :: Drop Down Access Standard Menu To Place Count Command
May 29, 2014I have been using a table with queries with no problems. Now the queries wont recognize the last two records of the table when doing a Count. there are no null or empty spaces. I am using the drop down access standard menu to place the "Count" command. Is there a solution to this problem ?
View 3 Replies View RelatedForms :: Option Group With Command Button
May 31, 2015I'm using option group with value 1 and value 2 with a command button to open two different forms. This is the code:
Code:
Private Sub Command9_Click()
Dim strForm As String
Select Case Me.Cornice0
Case Is = 1
[Code] ....
I would like to close form's option group once clicked the command button after the opening of the requested value form. I tried Docmd.close but all I get is the option group no more working.
Forms :: Command Bars Custom Shortcut Menu - Font Color Picker
May 15, 2014I am currently in the process of creating a pop-up menu to allow my users to do some simple text formatting.I have used the following code to do so:
Code:
Dim cmbShortcutMenu As Office.CommandBar
' Create the new pop-up menu instance
Set cmbShortcutMenu = CommandBars.Add("popupFormatMenu", msoBarPopup, False, True)
' Add the bold button
[code]....
The problem is that I now want to add the FontColor picker control and I keep getting an error.I think the problem lies in the type of control I want to add. According to the Microsoft support files I downloaded the fontColor control is of type Gallery and ID = 11949, so the code should look something like this:
Code:
cmbShortcutMenu.Controls.Add Type:=msoControlButton, id:=11949
I need to replace msoControlButton with something else.
Create Check Boxes/Option Buttons/Option Group Using VBA
Mar 14, 2008I’m really stuck on how to create: Check Boxes/Option button/Option Group in VBA.
Could someone help on either all of them or some of them please?
Thanks
Richard
How To Show A Full Menu On The Menu Bar
Feb 19, 2007Hi everyone,
I was trying out the options on the startup item of the tools item on the menu bar and my access window has gone except the following menu items: File,Window and Help.
Can someone kindly show me how to bring back these seemingly lost items?
Thank you for your willingness to help me out!
Blank Option (radio) Buttons In Option Group
Aug 18, 2006I am using an Access database for a foreign language dictionary project.
One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA.
This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad.
The form in question has an option group with 11 radio buttons that correspond to the parts of speech associated with each word in tblLEMMA.
When I click on the button optAdjective I apply a filter and the only records that are displayed are adjectives. (The same applies for Nouns, Verbs, Prepositions etc.)
Here is the glitch: even though the radio buttons apply the filter correctly, no “black spot” appears in the button. Other signals on the screen let me know what word type is selected, so I can accomplish what I want, but I want the “black spots” too!
Perhaps this will be a clue: For each radio button I use the following code in the GotFocus event.
Me.FilterOn = False
Me.Filter = "wordtype = 'A'" ‘(or N, etc)
Me.FilterOn = True
And this for the Lost Focus event
Me.FilterOn = False
Thanks for the help.
Select Option Group Option Based On Checkbox Value
Aug 22, 2005Hi
I've got an Option Group with 3 options; Yes, No and Future.
I also have a range of Check Boxes; 1 for every day of the week.
When one of the check boxes is selected I want the Option Group to change to Yes.
Currently, the Option Group defaults to Future and No will only be available by manually selecting it. This doesn't need to be changed.
Any help will be greatly appreciated!
Cheers