How to create a "Filter For..." Custom Shortcut menu

[AdamHope]

I want to create a custom shortcut menu bar (MS Access 2003), but include the "Filter for" option, which is in the default menu bar -

I can drag this option to a custom menu, but this then removes it from all default menus.

How can I make a copy of this, or create a new one? I Have also looked in the list of commands, but cannot see where this option filter for is.

Many Thanks

[NeoPa]

Unfortunately your picture doesn't give proper context to indicate where this is to be found. More importantly, your question doesn't either. It makes it very difficult to look into this for you.

With the proper information in the question we may be able to help. We can at least look into it for you.

[zmbd]

Create a custom toolbar (v2003 and earlier)

1.On the Tools menu, click Customize.
2.Click the Toolbars tab.
3.Click New.
4.In the Toolbar name box, type the name you want, and then click OK.
5.Click the Commands tab.
6.Do one of the following:

Add a button to the toolbar

1.Click a category in the Categories box.
2.Drag the command you want from the Commands box to the displayed toolbar.

Add a built-in menu to the toolbar

1.In the Categories box, click Built-in Menus.
2.Drag the menu you want from the Commands box to the displayed toolbar.
1.When you have added all the buttons and menus you want, click Close.

Note Custom toolbars (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) that you create are specific to the Access data file (Microsoft Access file: A database or project file. In Access 2007, database objects and data are stored in .accdb files. Earlier versions use.mdb files. An Access project file doesn't contain data, and is used to connect to a SQL Server database.). If you want to use a custom toolbar in a different Access data file, you must re-create or import the custom toolbar.

Also, your image is blocked from my WorkPC due to company policy, as are most file sharing sites; thus, in this case, a picture is worth very little. :)

[Tim Marshall]

Adam, zmbd has got it, but another way to do EXACTLY what you were doing using already built in menus, is, in customize mode, to HOLD THE CONTROL KEY DOWN (your cursor will have the arrow AND a little plus sign) as you drag the filter for control from the main menu.

Holding the control key is essentially making a copy before you begin to drag of what you'd like in your short cut, tool bar or menu bar.

Try it, it works!
--
Tim