I created a database in MS Access 2000 for the company I work for.
I sent this database from the US to our sister company in the UK, and the gentleman there has no right-click access within the data entry form.
Is there something that needs to be turned on or a check box that needs to be checked for right-click access within the program?

Thank you in advance.

Jason

In your Startup Options (Tools > Startup) make sure the checkbox "Allow Default Shortcut Menus" is checked.

The user does not get that option. He is running Access Runtime 2003 (which I am not familiar with). I received the following, but am not sure where to go to turn this switch on:

One hint: Jason can try how the database works with the runtime using the "/runtime" switch of Access.
Syntax is: "<Path to MS Access>\MsAccess.exe" "<Database to open>" /runtime
e.g. C:\Program Files\Microsoft Office\Office11\Msaccess.exe" "X:\Databases\MyData.mdb" /runtime

Thank you all in advance.

Click the Windows Start button, select Run and type or paste in the command line you have been given.

Oh, by the way, I discovered something with one of the databases here at work. They couldn't right-click when running it in runtime but could in the full-version. So, I had to go create a custom shortcut menu and then add that to each form and report that they wanted it available for. So, you may have to do the same thing.

I think that may be beyond what I am capable of doing.
My suggestion to them is to upgrade to the full version.
Thank you.

Jason

I think that may be beyond what I am capable of doing.
My suggestion to them is to upgrade to the full version.
Thank you.

Jason
Actually it's quite easy. When I get to work I'll post the instructions here. I just am not sure I remember all of the steps (although it's pretty easy) exactly.

But, in the meantime I believe it is:

1. Right-click on the tool bar and select Customize

2. In the Tool bars tab click ADD

3. Create a name like RClick

4. After clicking ok, select RClick and select PROPERTIES

5. Change the type from Toolbar to POPUP

6. Go find Custom Menu in the list of toolbars and check it

7. You should see Custom at the very end of a long menu list that appears above everything and select it to drop down RClick.

8. Select the Commands tab in the dialog where you added RClick

9. Drag and drop your commands up on the RClick menu that dropped down from that top bar.

10. Go into your forms and/or reports and in the SHORTCUT MENU property select RClick

and that should do it for you.

Bob,
I am lost at step 6. Once I turn the toolbar into a pop-up (Step 5),
the RClick disappears. Also, I do not understand Step 7.

Jason

I'll do up a set of pics for you. It may take a little while, but I'll start on it here.

Okay, here you go

http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu01.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu02.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu03.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu04.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu05.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu06.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu07.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu08.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu09.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu10.png

CONTINUED BELOW (due to posting limits of images)

Continued from above
http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu11.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu12.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu13.png


http://downloads.btlarson.com/AWF/screenshots/CustomMenu/custmenu14.png

I had to go back and add the last screenshot. I forgot I had 14 and not 13 of them.

Thank you. Bob. I got that to work.
Now when I load the database in Runtime, I am able to get the Right-Click option to work, but I need it to be for a hyperlink.
I entered Hyperlink from the Insert Menu selection, but the only things that show up are "New Record" and "Object".
Am I not entering the correct "Hyperlink" into the custom menu?

What do you mean you need it to be a hyperlink? What are you linking to?

The database is for housing drawing information (Company Name, Revision Level, etc...) and hyperlinks to the drawings located on the server.
See attached screenshot.

Do you need to be able to right-click and do it? You should be able to do it just by clicking on the drawing link text box.

Just set the text box click event to:

FollowHyperlink "file:///" & Me.YourTextBoxNameHere

If the textbox has the file path, that is.

If you just have the file name there and the path to the files is always the same you can use

FollowHyperlink "file:///C:\" & Me.Text2
or
FollowHyperlink "file:///\\YourServer\YourShare\YourPath\" & Me.Text2