If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Filter for ..." command on shortcut menu
I posted this in the
microsoft.public.access.commandbarsui group yesterday, but there's been no response so far, so I'll try here. The Datasheet View Cell menu (I'm using Access 2000) has a "Filter For" command - it has a text box beside it into which you can enter criteria eg. "a or b". I want to create a custom right-click menu for a form with this command as one of the options, but it doesn't appear in the list of commands available when I try to customize my menu. All the other Filter ... commands are available in the Records category, but not the one I want. I can't find it in any other category either. Where is it, and how can I add it to my custom menu? TIA, Rob |
#2
|
|||
|
|||
Hi, Rob.
Try adding the "Filter By Form" command from the "Records" category to your custom CommandBar. Just drag and drop the "Filter By Form" icon onto your custom CommandBar. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Please remove ZERO_SPAM from my reply E-mail address, so that a message will be forwarded to me.) "Rob Parker" wrote in message ... I posted this in the microsoft.public.access.commandbarsui group yesterday, but there's been no response so far, so I'll try here. The Datasheet View Cell menu (I'm using Access 2000) has a "Filter For" command - it has a text box beside it into which you can enter criteria eg. "a or b". I want to create a custom right-click menu for a form with this command as one of the options, but it doesn't appear in the list of commands available when I try to customize my menu. All the other Filter ... commands are available in the Records category, but not the one I want. I can't find it in any other category either. Where is it, and how can I add it to my custom menu? TIA, Rob |
#3
|
|||
|
|||
Sorry. I sent that message too soon. I should have explained that the
command you are looking for isn't in the "Commands" list box in the "Customize" dialog window, nor is it a filter command that you can call in a VBA function, so the best you can do with drag and dropping those commands is to add the "Filter By Form" command to your custom CommandBar. However, if you'd like an expert consultant to create this custom CommandBar shortcut menu for you, please contact Q-Built Solutions. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Please remove ZERO_SPAM from my reply E-mail address, so that a message will be forwarded to me.) "'69 Camaro" AM wrote in message ... Hi, Rob. Try adding the "Filter By Form" command from the "Records" category to your custom CommandBar. Just drag and drop the "Filter By Form" icon onto your custom CommandBar. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Please remove ZERO_SPAM from my reply E-mail address, so that a message will be forwarded to me.) "Rob Parker" wrote in message ... I posted this in the microsoft.public.access.commandbarsui group yesterday, but there's been no response so far, so I'll try here. The Datasheet View Cell menu (I'm using Access 2000) has a "Filter For" command - it has a text box beside it into which you can enter criteria eg. "a or b". I want to create a custom right-click menu for a form with this command as one of the options, but it doesn't appear in the list of commands available when I try to customize my menu. All the other Filter ... commands are available in the Records category, but not the one I want. I can't find it in any other category either. Where is it, and how can I add it to my custom menu? TIA, Rob |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to disable or remove Save button. | jdtivoli | General Discussion | 3 | July 27th, 2004 12:52 PM |
Shortcut Menu Item Disabled | JamesJ | Using Forms | 0 | July 17th, 2004 11:59 AM |
Office 2003 / Office XP Shortcut Bar | Marc Bressman | Setup, Installing & Configuration | 6 | June 26th, 2004 08:42 AM |
Office 2003 / Office XP Shortcut Bar | Marc Bressman | General Discussions | 6 | June 26th, 2004 08:42 AM |
Can "Filter for:" be used from non-shortcut menu? | Fred Boer | Using Forms | 2 | June 3rd, 2004 07:58 PM |