Forms :: Customize Right Click Menu

May 1, 2015

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

[Code] .....

View Replies


ADVERTISEMENT

Reports :: How To Customize Right Click Shortcut Menu In Access 2010

Mar 29, 2015

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.

View 3 Replies View Related

Customize Menu

Mar 15, 2005

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.

any help would be greatly appreciated. Thanks!!!

View 1 Replies View Related

Forms :: Pop Menu On Mouse Right Click

Mar 7, 2013

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 Related

Forms :: Right Click Menu In Popup Form On Access 2010?

Dec 11, 2013

I'm trying to do right click menu on listbox.

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

[code].....

View 3 Replies View Related

List Box (need Right-click Menu)

Aug 11, 2005

Hi All

A quick question.

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

Thanks Homer

View 1 Replies View Related

Allow Right-click Menu To Users

Aug 3, 2005

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

View 2 Replies View Related

Copy And Paste In Right Click Menu

Dec 27, 2013

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?

View 1 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

Modules & VBA :: Remove Items From Right Click Menu

Aug 18, 2014

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.

View 1 Replies View Related

Modules & VBA :: Click Button To Expand Whole Menu

Sep 17, 2014

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

[code]...

View 3 Replies View Related

Modules & VBA :: Right Click Menu Command Bar Index Number?

Aug 13, 2014

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

View 4 Replies View Related

Forms :: Customize A Form Using A Form

Jun 3, 2014

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.

View 1 Replies View Related

Just Need A Little Help To Customize.

Nov 26, 2005

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.

jbarnes

View 5 Replies View Related

Possible To Customize Autonumber In R...??

Mar 4, 2004

Hi all,

Is there any way to customize an autonumber field to be in the format Raaa, where aaa is in integers??

Thanks.

Rgds,
Tracy

View 14 Replies View Related

How Can I Add Forms And Reports To The Menu?

Aug 6, 2006

Hi all,
How can I add forms and reports to the menu?

Thanks and Regards

Mark K.

View 4 Replies View Related

Customize Error Messay

Feb 6, 2006

Hello all:

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.


Thanks for your help once again.

View 4 Replies View Related

Customize Input Mask

Feb 14, 2007

Friends,

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.

View 3 Replies View Related

Modules & VBA :: Customize Object Name

Mar 17, 2015

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.

View 1 Replies View Related

Forms :: Button Click Event To Choose Between Forms To Open Based On TextBox Input

Jun 7, 2013

Making a small database, Got 1 Table.

1. ContactDetailTable

Got 3 forms.

1. ContactIDForm
2. ContactInfoForm
3. NewContactFrom

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.

View 10 Replies View Related

Forms :: Combo Box Like Windows Menu Bar

Mar 23, 2013

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.

View 2 Replies View Related

Forms :: Drop Down Menu In Order

Aug 6, 2015

1. I have a drop down menu with numbers 1 thru 15

How do I have the drop down menu go 1,2,3,4, etc.

Right now it goes 1,10,11,12,13,14,15,2

Also I have two fields where the user enters money

2. How do I set up the form so when the user types in 430 it is 430,000.00 and not 430.00

View 1 Replies View Related

Forms :: Menu Form Keeps On Opening?

Jul 28, 2013

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!

View 7 Replies View Related

How To Show A Full Menu On The Menu Bar

Feb 19, 2007

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!

View 2 Replies View Related

Trying To Customize The Sample Contact Management DB

Jun 20, 2005

Hi,

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'll appreciate your help.

Orlando

View 1 Replies View Related

Customize The Sort Order Of A Combo Box

Dec 7, 2005

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.

all help is appreciated.:)

View 3 Replies View Related







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