Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: Can access filter down a list of text as you type?

Discussion in 'Information Technology' started by Nikki, Jul 28, 2006.

  1. Nikki

    Nikki
    Expand Collapse
    Guest

    Thanks.

    I have created various popup forms and one in particular come up blank. If
    I leave that form open but click the command button again then the fields and
    data appear but not the first time. Any ideas how I can fix this?

    Nikki

    "Tom Wickerath" wrote:

    > Hi Nikki,
    >
    > Yes, you can do this, but in order to do it as you type, you would need to
    > use the Keypress event. This would be a very "chatty" application which, if
    > ever put on a network and shared with multiple users, would likely be
    > unacceptably slow. My suggestion is to have a command button that would
    > perform the search only after you entered the desired search term. That way,
    > it would not retrieve different recordsets for each keystroke, as in:
    >
    > S ---> Recordset 1
    > Su ---> Recordset 2
    > Sup ---> Recordset 3
    > Supe ---> Recordset 4
    > Super ---> Recordset 5
    >
    > An idea that is similar is shown in this article:
    >
    > Access Cookbook
    > Chapter 8 Excerpt: Make Slow Forms Run Faster
    >
    > http://msdn.microsoft.com/library/d.../en-us/dnacbk02/html/ODC_CookbookChapter8.asp
    >
    > Look for the section titled: "Combo and list box controls".
    >
    >
    > Tom Wickerath, Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "Nikki" wrote:
    >
    > > Is there a way that I can make access filter down a list of records as I
    > > type?
    > > Like if I typed 'super' it would bring up everything that has super at the
    > > beginning, but as I continued to type 'supermarket' it would only show the
    > > ones with supermarket at the beginning.
     
  2. Loading...


  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    I can't really help with such limited information. What is the code behind
    the command button? What is the recordset for the pop-up form that initially
    opens empty? Is the pop-up form bound or unbound? Is there a network
    involved? Lots of details that might be involved. Can you fill in some of the
    blanks?


    Tom Wickerath, Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Nikki" wrote:

    > Thanks.
    >
    > I have created various popup forms and one in particular come up blank. If
    > I leave that form open but click the command button again then the fields and
    > data appear but not the first time. Any ideas how I can fix this?
    >
    > Nikki
     

Share This Page