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.
i need the way for making a popup menu on the right clic of the mouse inside a form...so when i pree right mouse button i will have my list with my commands.
View 8 Replies View RelatedHelp! I'm not sure how I did this, but NO matter what database I go into i can see any toolbar or menu bar. Yes I tried the shift key. How do I turn it all back on?
When I right click I can get the database startup properties, everything has the check, yet I can't see any toolbars or menu bars. I've searched though the help, and I can't see to find out how to put it back.
What is the best way to turn all the menu bars and tools bars off and back on when a form opens and closes? Can you just loop through the numerated objects?
View 14 Replies View RelatedGreetings.
I am pulling my hair out trying to create a customized menu bar. Eventually, I want to have a customized menu bar and tool bar for report and different customized menu bar and tool bar for forms. I created the tool bar for the report window. Then when I tried to create a new menu bar I could not remove menu selections without removing the same menu selections from the default Menu Bar.
I selected View->Toolbars->Customize...
Then I clicked on New (command button)
Then I named it (RptMenuBar)
Then I selected 'Built-In Menus' from the Commands Tab
Then I dragged the 'File' from the Command list into the new Menu Bar
Then I went to the new menu bar and dropped down the selections under File and started to left click and drag what I didn't in the NEW MENU BAR. However, it turns out when I did that the same selections were removed from the default Menu Bar.
I was ablel to restore the default Menu Bar. But I want to have a customized Menu Bar and be able to select that new Menu Bar and associate it with every Report that is in my Database.
Any ideas? If you have some good instructional references, please point me in that direction. Thanks.
SueB
I 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 RelatedI use Access 2007.I have a db split in FE(forms, queries, vbcode) & BE(tables only).I want users not to be able to view or explore the tables, the queries, the form design and details, in both Ends.Unfortunately, even disabling via VB code the menus, the db window, the tool & status bars, they appear and are accessible to the users (it only works in a non-split db, turned to an accde).
How can I disable any view on forms, queries, vbcode and tables details and data to users, in both FE and BE and only allow them to add data through specific form?
I 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.
Hi everyone. Listen, is there a way to disable the mouse wheel from scrolling through entries in a form? I would like to do this in order to not confuse and upset the user further in the database I am developing, since they do have to enter data into it. Please help me.
Thanks,
LookingMoney
On the database I am working on, it would not be convenient for me to install the mouse scrolling that determines if the mouse should scroll down the form, or to the next record.
That is a nice feature, but more than I need.
I only need to disable the mouse scroll bar (so the users do not get confused and then update the wrong record). Is there an easy way on the open of a form to completely disable the mouse scrolling feature?
Thank you,
TJ Bernard.
Hi everyone. Listen, is there a way to disable the mouse wheel from scrolling through enteries in a form? I would like to do this in order to not confuse and upset the user further in the database I am developing, since they do have to enter data into it. Please help me.
Thanks,
Spicoli
I have been running in this problem and i didnt know the cause but ive just realized now.
A mouse over the print button on the Menu Bar hangs my A2K for some Minutes. Other buttons on the menu bar dont.
A network printer is the default on my PC, but this is of as for now,it needs servicing. I dont know whether it automatically detects the printer settings on mouse over it :confused:
Can anyone tell me how i disbale mosue wheel scrolling in a form?
Thanks
My application retrieves a recordset with some records. Each record is presented separately on a form and there is a "next" button to move on. For each record it allows pressing a button on the form for activating MS Word that in turn opens a relevant document.
The problem is that while the MS Word document is open, mouse wheel scrolling scrolls the recordset in the MS Access application, so to move to other records, up or down. It is strange since the MS Word application is the active window at that time.
I would like to disable the mouse wheel for the MS Access while keeping it active for the MS Word. So a solution of disabling the mouse wheel totally is not what I'm looking for.
Thanks in advance
Hi!
I want to disable the usage of mouse scroll on my forms. Because, as things are now, you may accidently choose/ scroll to another Record/ Post, when editing data for one specific record.
How do I accomplish disabling usage of mouse scroll?
I would like to add to my form the ability to right mouse click to print a report, is it possible to achive this and if how can I.
Regards - Paul
I want to be able to automaticallly send a mouse click in response to a message using a Macro or VBA code. Is this possible, Any suggestions appreciated
thanks
I'm trying to disable mouse scroll wheel on the form but no luck here,
View 1 Replies View RelatedHi,
Is there a way to force a left mouse click in VBA?
How can i deactivate mouse second button click on form?
Can anyone help me please?:)
How can I move to control on form when user clicks on another control on same form? In other words... have set validation on controls and unless I disable all the other controls on form until I need it enabled, user can click on other control and get out of the validation sequence. Need to send user back to control they were on when they click on a different control elsewhere...
View 3 Replies View RelatedI want to handle the event when I right click and choose "Paste" to pop up a message to the user that he cannot paste; disabling the pasting functionality.
I understand that the Button parameter refers to right or left button , but on which event to best use (mouse up ,mouse down , mouse move - as it seems to be a mixture of the three) and the code for that event.
Code:
Private Sub List_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
' See if the right mouse button was clicked
If Button = acRightButton Then
'DoCmd.CancelEvent
'do event here
End If
End Sub
I don't want to cancel after there is a right click , but rather after right clicking and choosing "Paste".
How to open a search form with a mouse click on Button_Search
My idea is to pop up a form where user can enter the search text and select the required name and get back to the old form with all details about the entry. This form alone is workign fine. I want to call it in a mouse click. and pass the data back to old form.
I have a form (about patients) containing a listbox (list of visit dates) and a subform (showing medications at that date). When you click on the listbox, the subform is re-queried with the selected date as a parameter to show the medications that were in use on that date. This is working fine.
However, when you move to a new record (patient), the subform is initially blank because the listbox hasn't been clicked on yet. This means that it looks like the person isn't on any medications, which is causing some confusion.
I need a way to have the subform show the "top" (most recent) date because that is the current medication list, and the thing most people want to see first. It is always the top of the list, so I would like to do something like this (pseudocode)
Code:
Private Sub Form_Current()
Forms![MedSearch].SelectDateBox.Requery
Send MouseClick Event to line 0 of SelectDateBox
End Sub
I get a bizarre situation while I am using MS Access 2010 to select values with Combo Boxes on a form, i.e.:
* After I select one or more values from the drop-down list of a Combo Box, there is no response when clicking OK button using the mouse. It is stalled. I need to do the process again and then the mouse-click on OK button could work: click anywhere outside of the combo box, re-select the values, click OK Button, and done.
* However, I can always use Enter key (on the keyboard) upon OK button to complete the selection.
* The values in the drop-down list of the Combo Box were entered manually.
What is wrong with the combo boxes on the form? Why do I need to do twice to complete the selection using mouse-click? Why the keyboard-click ('Enter') can be always OK but not for the mouse-click?
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?