A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Filter for ..." command on shortcut menu



 
 
Thread Tools Display Modes
  #1  
Old September 10th, 2004, 01:53 AM
Rob Parker
external usenet poster
 
Posts: n/a
Default "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  
Old September 10th, 2004, 04:35 AM
'69 Camaro
external usenet poster
 
Posts: n/a
Default

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  
Old September 10th, 2004, 05:03 AM
'69 Camaro
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.