General :: How To Disable Menu Choice

Jun 16, 2014

I 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 Replies


ADVERTISEMENT

Mde - Disable Menu Options

Apr 20, 2006

I'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?

View 2 Replies View Related

Disable Menu-Command Option

Apr 25, 2005

With 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"

View 1 Replies View Related

Disable Restore Button On Menu Bar

Jul 23, 2005

Is it possible to disable the Restore button that's displayed on the menu bar when a form is maximised?

View 2 Replies View Related

Disable Tool-Bar Menu - 'Delete Record'

Apr 20, 2006

Hello 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
:)

View 7 Replies View Related

Disable Menu Paste Option In Combo Box

Oct 18, 2006

I'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?

View 2 Replies View Related

Disable All Menu Bars Except The Right Click Mouse

May 1, 2006

Hi,

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.

View 1 Replies View Related

General :: Custom Table Based On Users Choice Of Fields

May 15, 2013

I want to create a form where by the user can select the fields he requires and the table is created.

Example: I have a table of subjects like maths, english, french, chemistry etc,

The user can choose what subjects are available in that particular school and therefore a table is created based on the chosen subjects.

Is there any way it can be done even with vba?

View 4 Replies View Related

General :: Grayed Out Subform Menu

Jul 22, 2013

How to activate the subform menu for MsAccess 2003 on a XP O/S.

View 1 Replies View Related

General :: Reset Default Menu Bar?

Dec 12, 2012

I just change my default menu bar in access from start up option. And created a new menu with some sub menu which I want. But when I remove all tick mark from different toolbar and only select my new menu, I can't show default menu bar again. How I can show default menu bar?

View 8 Replies View Related

General :: How To Disable Main Screen

Jun 8, 2012

Is there anyway to diasble the window that has the circle in the left hand. When I open my database I just want the form to open. I dont want the window with the toolbars to open it jus gets in the way an is more of a hassle to deal with.

View 3 Replies View Related

General :: Disable Security Warnings

Sep 21, 2012

I will be sending out copies of a program to several locations. Once I send the program I have absolutely no control over it. The FE file will always be in the same folder. The setup process creates C:MyFolder with the FE file in there. Is there a way to to programmatically disable the warnings throughout setup or to make C:MyFolder a trusted location?

View 3 Replies View Related

General :: Creating Custom Menu Bar For Form?

Jul 2, 2012

i would like to create custom menu bars for my forms report

View 6 Replies View Related

General :: Need To Change A User Created Menu

Aug 6, 2014

I have a database that was created in Access 2003. I'm using this MDB in Access 2010.I need to change a user created menu. The update involves changing an existing entry and adding a new menu item. The menu looks like:

Project
Time Entry
Time Spread

I need the "Time Spread" to change to "Time Spread Daily" with a changed macro name. After that a new menu entry is "Time Spread Monthly". This menu will run a new macro that will display a form.I think the only way to do that in 2010 is to use VBA.

View 1 Replies View Related

General :: Disable Import Of Access ACCDB?

Jul 4, 2013

I have a .accdb with security where ihave hidden navigation pane and toolbars...

Now left with one more thing, is it possible to disable anyone trying to import stuff from my database?

Maybe some code or is there a setting somewhere in current db?

View 5 Replies View Related

Forms :: How To Disable Edits In General Tab But Not In Calls Tab

Apr 9, 2013

I have a form called Contacts that has two tabs. One is called General adn the other Calls.

In the General tab I have a bound field called CustomerIDdet which can be numeric or alphanumeric. I need to disable edits in the General tab but not in the Calls tab if CustomerIDdet is numeric (and it follows certain additional rules)

I have placed this code in the Onload even for the form:

Code:

If Len(CustomerIDdet) = 9 Then
If IsNumeric(CustomerIDdet) Then
If Right(CustomerIDdet, 4) = 9090 Then
If Left(CustomerIDdet, 1) = 0 Then
'disable editing in the General tab
End If
End If
End If
End If

I know how to disable edits control by control, but can I disable edits in all controls in that tab at once?

View 2 Replies View Related

General :: Function To Enable / Disable Screensaver

Jun 10, 2015

I need an Access 2010 function to enable/disable screensaver on W8.1

View 1 Replies View Related

General :: Command Button Enable Or Disable

Jul 27, 2012

I 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

View 1 Replies View Related

General :: How To Disable Textbox After Saving Data

May 6, 2014

I have some field in my details section,It works like a grid view,if I search data by query then It shows all of the related data from database,then I edit or save data one by one,but the problem is I want to disable text box after edit/save data.But if I write code like--

If Me.Text103 > "" Then
Me.Text103.Enabled= False
Else
Me.Text103.Enabled= True
End If

It disable the all of the rows,but I want to disable only the specific field where I enter the data.

View 4 Replies View Related

General :: Disable Printing Of All Records In Forms

Feb 5, 2013

Is it possible to disable the printing function in a form ?

We are getting people clicking the print icon when viewing a single form record. This results in the printer printing all records !!

View 2 Replies View Related

General :: How To Hide Or Disable The File Tab From Front Ends

Apr 12, 2013

How do I hide or disable the File tab in Access 2010 on my front ends?

The file tab being present allows end user to get into Privacy Options and Printing. Printing is okay if I could disable the Privacy Options for end users, then it wouldn't matter if they have access to the File Tab.

Possible very serious security issue!

View 2 Replies View Related

General :: Disable Close Button Access 2013

Jul 18, 2013

how to disable the main close button so the user is forced to click the Quit Application button on my main switchboard?

View 8 Replies View Related

General :: Disable Home Screen For Front End Users?

Jul 23, 2014

I have a database that logs people in and out. Works great unless the user minimizes the navigation page and clicks the X on the main Access Page. I have to keep the minimize button active on my nav page.

Is it at all possible to disable the main access page for the user?
If not, is it at all possible to set a logout macro to the X button on the main page?
If not, is it at all possible to set a logout macro to activate on "Quit Access"?

View 4 Replies View Related

General :: How To Edit Access 2010 Default Shortcut Menu

Dec 10, 2014

I am building a db and i want to disable the Shortcut Menu (pull down menu at form's title bar) to prevent the users from closing the main form.

There is a Disable Shortcut menu setting in the File/Options menu but the whole db gets the setting.

I simply want to deny the users from accessing the Shortcut Menu when on the Main Menu (or a particular form) but allow it on other forms where Printing is required via the Shortcut Menu.

Im looking at 2 options; edit the shortcut menu or force a form to disable that w/o affecting other forms.

View 3 Replies View Related

General :: Open Save Backup As Dialogue Box From File Menu

Sep 20, 2012

I want to open the 'Save Backup As' Dialogue Box from the file menu, using a Command Button on a Form in Access 2003.I know you can do this manually but I would love to do it programically.

View 4 Replies View Related

General :: Lock / Unlock Full Menu Based On A Password

Sep 28, 2014

I want to lock down and unlock the full menu based on a password..

For instance upon load of the database I would like it stripped down when a general user logs in... but if a admin logins in then they get all menus...

so based on the user type will dictate the menus visible.. cane this be achieved'''''''''''';

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved