I have the following script which customizes the right click menu.
The problem that I am having is that I call the script to add the right click from the form open event and then multiple users can not access the same database.
I use one for forms and then another for reports.
If I manually close the open forms then reopen them then multiple users can use the same database.
If I close and reopen forms with vba the right click still remains making the database not accessible to multiple users.
It is definitely this as when I comment it out from the open event of the forms then everything is OK.
I call the following from the open event of the form as follows
Code:
Public Sub Form_Open(Cancel As Integer)
FormsShortcutMenu
End Sub
The following is stored in a module
Code:
Public Sub FormsShortcutMenu()
Dim cmbRightClick As Office.CommandBar
Dim cmbControl As Office.CommandBarControl
On Error Resume Next
CommandBars("cmdRightClick").Delete
how to customize my right click "Short-cut" menu in Access 2010. I need a right click menu with ONLY the "Print" and "Print Preview" options for my reports and I would like to disable right click in all other objects.
I'm currently using Microsoft Access 2000. In there I've created a Customized Menu. Now what I'm looking to do is - when I click a menu item, I want it to enable another menu item. I tried using "SetMenuItem Action" but it keeps on telling me that this function only works with customized menus. I'm sure I created a customized menu.
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.
currently i'm trying to implement a right click menu which will show a simple messege box.
My problem is that the list box is on a pop up form which opened up maximized. Now when i'm right clicking on the list box i see the right click menu but when i'm clicking on one of the menu options, nothing happenning (it seems that it don't go to the function as it should). i've also putted breakpoints on the function but it never tips.
It's important to mention that if i'm setting the form popup option to no the right click menu works perfectly (when i'm clicking on one of the options i see its matching messege box).
I'm running the following vba code:
This is the mouse up event handler for my list box:
Private Sub Song_List_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) ' Call the SetUpContextMenu function to ensure it is setup with most current context ' Note: This really only needs to be setup once for this example since nothing is
[Code] .....
setting up the "SetUpContextMenu" sub:
Public Sub SetUpContextMenu() ' Note: This requires a reference to Microsoft Office Object Library Dim combo As CommandBarControl ' Since it may have been defined in the past, it should be deleted, ' or if it has not been defined in the past, the error should be ignored
Is it possible/Easy to wipe out the standard menu for right clicking a listbox and replacing it with a custom menu.
I would like to make some custom functions for adding and deleting records using list box contol instead of having a huge amount of buttons all across the screen
I have locked my db down so that no one can use the right-click options will in it. I did this to lock them out of the filters and properties options. Does anyone know how I can allow them to use the right-click with the mouse to only do cut, copy, paste, and hyperlink? Thanks
I am making a custom right click menu for our company database using this tutorial:
[URL] ....
The thing I can't find when making this macro is copy or paste. I want to add these to it but I can't find it using run command or anything. How to get these 2 in the menu?
How do I remove items from a right click menu in access 2003? For example I need to remove the form view / design view button from a right click menu but i want to keep the hide/show columns button on the same menu.
the login is working perfectly, once It logs in there is a button to expand all that is based in JS. I can't seem to work out how to get it to click the button to expand the whole menu, latest code is below:
Code:
Option Explicit Function Checkpage() Dim IE As Object Dim lform As Object Dim Document As Object Dim item As Object
I have this database, and it was always customized every month. Is it possible if Access will customized the form using a form? The form has a category Order and under Order there are different order names to be checked, is it possible if the user will just add another order name and it will be added on the form.
Ok, I got this template from the Microsoft Office template site. I want to customize it a bit, but I have been trying and trying and cannot get it to do what I want. I would like to get rid of the - after the postal code, so that it looks like 68214 instead of 68214-. I have attached the file if anyone is willing to take a look and edit it for me or if you could try it out and explain how to do it. Any help is greatly appreciated.
Thanks for all your numerous help. I posted this earlier, but got no response, your urgent help is required.
I usually get 2 error messages on my form.
When I set up the table, I made the date field mandatory. The first error message, error 3314, "The field 'Memo.Date' cannot contain a Null value because the required property for this is se to True. Enter a value in this field"
I would like to change this error message to: "Enter Date of Memo"
The second error is: Microsoft Visual Basic Run-time error '490': Cannot open the specified file
End Debug buttons.
I would like to change this error message to: "The file does not exist/it has not been previously saved."
And I don't want the End or Debug buttons to show.
I would like to create my own input mask for a ssn field. The problem is that my ssn field has 13 characters (text) and the following format 000-00-0000xx.
The xx stand for any additional 2 characters.
Is there a way I can create an input box for a similar format? Thanks.
When we use DoCmd.SendObject, the object name is always the same name of table, query or report.Can we customize object name to something else more descriptive? For example:
If I send the report "SalesPerSalesman" about John Smith, the object name now is "SalesPerSalesman.pdf" If i send the report "SalesPerSalesman" about Maryann Johns, the object name would be again "SalesPerSalesman.pdf"
However , the object name I would like "SPS_JohnSmith.pdf"and the report for Maryann Johns, I would like as object name "SPS_MaryannJohns.pdf"
Syntax DoCmd.SendObject ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile ObjectName � Name of table, query, Report etc.
In ContactIDForm it contain 1 textbox name 'TextBox' with Button Name 'Btn'
In ContactIDForm there is only 1 Text Box ContactIDTextBox and 1 Button. User Enters ID in TextBox and On Button Click Event it should check data from TextBox in Table name (ContactDetailTable) in field ContactID and if there is record matching, ContactInfoForm should Open else NewContactForm should open with ContactIDTextBox value in it.
I'm trying to get a drop down menu to select a category then select a sub group based on that choice. Having two boxes is not an option. It has to be from just one box this is because the category is not important and the data to be saved is just from the sub group.
I have a series of forms. The 1st form is my main menu. On this form I have 5 command buttons which gives the user options to ...
Button1 - Enter Station Scores Button2 - Print Performance Sheets Button3 - Print Audit Sheets Button4 - System Administration Button5 - Quit
When the user clicks one of the buttons (with the exception of the Quit button) I perform the following code (This code is for the 1st button)...
Code: Private Sub cmdEnterStationScores_Click() ' Open select workstation DoCmd.OpenForm "frmSelectWorkstation", acNormal, , , , acWindowNormal ' Close main menu DoCmd.Close acForm, "frmMainMenu", acSaveNo
End Sub
So far so good...
The "Select Workstation" form opens fine with no sign of the main menu. I have a "Continue" button on this form which opens yet another form using the following code...
Code: Private Sub cmdContinue_Click() ' Delete workstation name Call DeleteWorkstationName ' Store selected workstation Call StoreWorkstationName(strSelectedStation)
[Code] ....
...For some reason the "Main Menu" form reopens itself at the same time as the "Enter Sort Scores" form, so I have 2 forms on the screen, with the "Main Menu" screen on top.
Why does the Menu form re-open?
I have set breakpoints in every bit of code I have and stepped through it all, but nothing I can see references the Menu form!
Hi 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!
I need to customize the sample Contact Management DB (CONTACT) that comes with MS Access 2000.
I removed the field ‘Region’ in the ‘Company’ table, in the ‘Company’ form, and in the ‘ContactAddress’ query, respectively. Now, when I try to access the ‘Enter/View Contacts’ form through the Main Swithboard's button, it shows a small warning windows asking to ‘Enter Parameter Value’, referring to "Company.Region." What did I wrong and/or should I do to correct this problem?
i have a combo box on a payment form which shows existing permit #s. i'd like to make the sort order show the most recently added permit first. i clicked on the build button next to RowSource on the data tab of the properties of the combo box which opens the query my combo box is based on. there are only 3 sort order options...ascending, descending, & not sorted. can this be done?
the permits form has a button to open the payments form (payments can also be opened alone too - ie. if somone applies for a permit today but pays for it tomorrow...). usually this will not be the case but that is why i have to keep it either combo or list.