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  

Dynamic filtering



 
 
Thread Tools Display Modes
  #1  
Old August 20th, 2008, 03:44 PM posted to microsoft.public.access.forms
John F[_2_]
external usenet poster
 
Posts: 18
Default Dynamic filtering

What I want to create is a dynamic filter that will narrow down your choices
as you type in a combo box.

I.E. The selection narrows as you type "a" will display all that starts with
"a".
Continue to type "ab" displays all that start with "ab" then by the time you
have typed "aba" you may now only have 3 or 4 choices to choose from and
clicking one will bring up that record for viewing or modification.

I have seen it done in web based database front ends. Is there a way to do
this from a form control?
  #2  
Old August 20th, 2008, 04:09 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default Dynamic filtering

The standard form filter is:
Me.filter = "[youridfield] = """ & Me.combo# & """"
Me.filteron=true
Then check with Allen Browne at www.allenbrowne.com to get the search as you
type part.

"John F" wrote:

What I want to create is a dynamic filter that will narrow down your choices
as you type in a combo box.

I.E. The selection narrows as you type "a" will display all that starts with
"a".
Continue to type "ab" displays all that start with "ab" then by the time you
have typed "aba" you may now only have 3 or 4 choices to choose from and
clicking one will bring up that record for viewing or modification.

I have seen it done in web based database front ends. Is there a way to do
this from a form control?

  #3  
Old August 20th, 2008, 05:20 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Dynamic filtering

That is the usual behaviour of a combo box. Just be sure the Auto Expand
property is set to Yes.
--
Dave Hargis, Microsoft Access MVP


"John F" wrote:

What I want to create is a dynamic filter that will narrow down your choices
as you type in a combo box.

I.E. The selection narrows as you type "a" will display all that starts with
"a".
Continue to type "ab" displays all that start with "ab" then by the time you
have typed "aba" you may now only have 3 or 4 choices to choose from and
clicking one will bring up that record for viewing or modification.

I have seen it done in web based database front ends. Is there a way to do
this from a form control?

  #4  
Old August 20th, 2008, 05:36 PM posted to microsoft.public.access.forms
John F[_2_]
external usenet poster
 
Posts: 18
Default Dynamic filtering

Yes but by default it shows all. What Im looking for is to only display
matching criteria hopefully limiting possibilities of mis-selection. The
above post appears to fit the bill, but I have not been able ti investigate
fully.

Thanks.

"Klatuu" wrote:

That is the usual behaviour of a combo box. Just be sure the Auto Expand
property is set to Yes.
--
Dave Hargis, Microsoft Access MVP


"John F" wrote:

What I want to create is a dynamic filter that will narrow down your choices
as you type in a combo box.

I.E. The selection narrows as you type "a" will display all that starts with
"a".
Continue to type "ab" displays all that start with "ab" then by the time you
have typed "aba" you may now only have 3 or 4 choices to choose from and
clicking one will bring up that record for viewing or modification.

I have seen it done in web based database front ends. Is there a way to do
this from a form control?

  #5  
Old August 20th, 2008, 05:51 PM posted to microsoft.public.access.forms
John F[_2_]
external usenet poster
 
Posts: 18
Default Dynamic filtering

Gets very close to what I am looking for. I will take a bit of modification
but I think that I can make it work.

Thanks

"Golfinray" wrote:

The standard form filter is:
Me.filter = "[youridfield] = """ & Me.combo# & """"
Me.filteron=true
Then check with Allen Browne at www.allenbrowne.com to get the search as you
type part.

"John F" wrote:

What I want to create is a dynamic filter that will narrow down your choices
as you type in a combo box.

I.E. The selection narrows as you type "a" will display all that starts with
"a".
Continue to type "ab" displays all that start with "ab" then by the time you
have typed "aba" you may now only have 3 or 4 choices to choose from and
clicking one will bring up that record for viewing or modification.

I have seen it done in web based database front ends. Is there a way to do
this from a form control?

  #6  
Old August 20th, 2008, 05:57 PM posted to microsoft.public.access.forms
John F[_2_]
external usenet poster
 
Posts: 18
Default Dynamic filtering

The post from Golfinray is very close to what I am looking for. It allows a
person to find items in the middle of the field. Which allows the operator to
not have to know if the record has "The" in front and still find the
information. But thank-you.

"Klatuu" wrote:

That is the usual behaviour of a combo box. Just be sure the Auto Expand
property is set to Yes.
--
Dave Hargis, Microsoft Access MVP


"John F" wrote:

What I want to create is a dynamic filter that will narrow down your choices
as you type in a combo box.

I.E. The selection narrows as you type "a" will display all that starts with
"a".
Continue to type "ab" displays all that start with "ab" then by the time you
have typed "aba" you may now only have 3 or 4 choices to choose from and
clicking one will bring up that record for viewing or modification.

I have seen it done in web based database front ends. Is there a way to do
this from a form control?

 




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


All times are GMT +1. The time now is 02:16 AM.


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