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?
ADVERTISEMENT
Lost A Bunch Of Menu Options!!! How To Get Them Back?
Nov 5, 2006Hi.
I lost a bunch of menu option sin my MS Access. In the Tools menu, almost everything is disabled (including Options) and in Add-Ins, all I have is the Add-In manager -and it doesn't seem to work as I readded all the add-ins and there ain't there.
I tried repairing, uninstalling and reinstalling Access from MS Office 2003 but I still have the same issue...
Is there a way to reset to orginial config?
Thanks,
Ben
Restore Menu When Removed Using ACCESS OPTIONS
Aug 9, 2011Is there any way to restore menus/editibility when they have been removed using ACCESS OPTIONS > CURRENT DATABASE then uncheck 'allow full menus'? Database was created in Access 2007. I always keep a back up of the pre-menu-disable state of my databases, but this is someone elses for which I can't find a backup.
View 2 Replies View RelatedLimiting Popup Menu Options In Add Or Edit Mode...
Sep 12, 2005Can someone point me in the right direction?
I have added a popup menu to my form to reduce the number of buttons needed. I would some of the options only available in the add or edit mode. Because its not a traditional button i dont think conditional formatting applies. Can someone give me a hint where I should be heading?
Forms :: How To Create Custom Menu Options In 2010
Sep 15, 2014How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.
View 3 Replies View RelatedForms :: User View - Reduce Amount Of Options On Menu Bars
Aug 15, 2013I have created a front end and put into production for my users but I want to reduce the amount of menu bar options they see so someone cant click on a button wondering what it does and mess something up. What is the best way to reduce the amount of options a user sees on the menu bars when they open the front end of the db?
View 1 Replies View RelatedDisable 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"
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 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?
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.
How To Hide Or Disable Print Or Quick Print Options
Dec 4, 2014I have a form which my company wanted that each single record should be printed from form. I made a print record button and put code to print single page or record. However as a natural habit people go to file > print to print which leads printing all records so 1000's records start printing. Is there any way i can hide print button. File >Print button.
View 1 Replies View RelatedHow 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!
Drop Down Menu Inside Drop Down Menu
May 15, 2006Ok, This is something I have long wanted to do, but cannot figure out.
I am working on a database for a company that orders a large number of Items. I have these all in one table (itemCode, itemDescription, price, categoryCode, etc). I have another table with categorys (categoryCode, categoryDescription) . Each Item is asigned a categoryCode and the appropiate relationship exsists. Right now I have a comboBox in a form that when selected opens a drops down menu with all the Items. Then another one auto loads up (continuous form) and I get the same drop down list of all the Items.
What I would like to have is a combo box then when it is selected shows the categorys, then based on that selection, I see all the Items that are in that category.
I guess another way of saying this simply is, I would like to create a drop down menu inside of a dropdown menu.
Is this possible? Does anyone have another alternative suggestion that might work well? I'm relectant to use a list box, becoase ideally it would be a drop down menu inside of a drop down menu as seen on many websites.
Thanks in Advance!
:)
Options To Use For A Small App
May 10, 2005Hi,
I was using access 2000 to build a small office app. It will be on a network and will generally be used by only 2 or 3 people(max). I was wondering if the default jet technology would be good enough for this. If it isn't, what should I use? I looked at other options such as msde and ado but it's a bit confusing when you're new to this stuff.
Thanks,
scratch
Saving Options?
Aug 10, 2005I'm trying to create a database for a taxi-type service that runs on thursday, friday and saturday nights. My question is: Is there a way to save the database at the end of the night separate from the previous nights, and so that the database is empty for the next night, but reports can be viewed for all of the nights combined?
Any help would be greatly appreciated!
-Rusty
Need Help Trying To Understand Options
Jan 18, 2006ok I have an access db which is all on access. the dbase has been operational now for 3 years and working well however, do to business needs and changes I'm trying to figure out a better way to collect and share data.
So the backend of the database is stored on our local office server when users log on to enter or review data they must be in the local office. We now had the need to access the database remotely from customer sites. Now the way this works is we use a local dialer to connect to our company's network and then are routed to our local server (you can imagine how slow this is) it is impossible to operate the current database this way. So I have been reading different posts and different options (front page, sql, asp etc.) What
I would like to do is convert my dbase to a program which can allow input and review of data both remotely and locally without a huge speed loss. What is the best approch for me?
thanks
jon
Start Up Options
Sep 5, 2006Hi,
I unticked all the boxes in the Tools > start up window. I closed my database then reopened it. Now, I can't put these settings back again as I can't see the Tools tab.
Any help will be very much appreciated.
B
No Options For AcHidden
Apr 10, 2007Hi, i need to hide a report when it is opened in another function with
DoCmd.OpenReport rptName, acViewDesign,,acHidden
but it does not allow me the full set of arguments! why!?
cheers
Tania
Enabling Options
Jan 17, 2008I'm by no means an expert when it comes to using access and its many controls that are avaliable to use on forms. Thats why I've come here to seek your help.
I have a database that has been created by someone who has now left the company and it needs a little work done to it.
The ideal thing we would like to get working on form, is that we would like a number of options to be greyed out and only accessable when another option is ticked.
I'm not sure how to group these options together, nor an I sure how make them active only when an specific tick box is ticked. Any help would greatly appreciated on this matter.
Thanks for your time and patience.
Menes.
IIF Condition With 3 Options
Sep 23, 2005:o Please help... I am trying to get the following results. If the Qty is less than 99 bag 10 per, if the qty is between 100 and 999 bag 100 per and if the qty is greater than 999 bag 200 per.
Pkg Qty: IIf([QTY]<=99,"10 PER",(IIf([QTY]>99,"100 PER",IIf([QTY]>999,"200 PER"))))
I am only getting the results of "10 PER" AND "100 PER". How do I get the results I want?
Print Options
Feb 17, 2005I ned to create a form that asks the user which reports they want to preview/print. I see it as a set of tick boxes with one saying all, then a print button. Im not really sure though, can someone offer some advise or maybe an example?
View 5 Replies View RelatedPrinting Options
Feb 28, 2005Hi,
How do i create an option inside the form, such that when the user ticks this option, it will print the form in this particular report. If user ticks another option, it will print the form in another particular report format... Thanks...
Mouse Options
Jul 14, 2005Is there an option so that turning the mouse wheel will scroll through the screen rather than scrolling through the different records in a form? Thanks! :confused:
View 3 Replies View RelatedOptions In A Form
Aug 31, 2005I am a bit of a beginner to Access 2003, and I would appreciate any help you can give me? :)
I have a drop down box on a form in Access 2003 with several options when an option is selected from the first drop down I would like a sub catagory of the selected drop down option to appear in the second drop down menu.
For example:
First drop down Hair, Clothes,
If you select Hair it then give the products relating to hair which need to be choosen in the second drop down menu.
I hope this makes sense.