Re: Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin Spencer (kevin_at_DIESPAMMERSDIEtakempis.com)
Date: 03/09/05 

Date: Wed, 9 Mar 2005 09:48:26 -0500

Let's have a look at the actual query.

The behavior you're describing is correct for a wildcard search. I don't
know anything about your requirements, however. If you want to search for a
state, how about using a drop-down list box? One of the purposes of a
drop-down list box is to prevent user error in typing in search values. 

-- 
HTH,
Kevin Spencer
Microsoft MVP
.Net Developer
What You Seek Is What You Get.
"L" <L@discussions.microsoft.com> wrote in message 
news:4F1293A4-AB9B-4758-9AD2-097AA9455272@microsoft.com...
>I have used the query designed for the Select All values by using the
> wildcard "*" and using the word "contain". The problem that I am having 
> now
> is that if I select Virginia, records with West Virginia are showing up. 
> If I
> use the criteria using the word "equal" then the select all query results 
> are
> not being displayed.  Does anyone have any clues?

Relevant Pages

  • Re: Can I use FindRecord in a form to find a record on a another Form
    ... If you have an unbound textbox on the switchboard from, where you can enter the Project Name, then you can make a Query based on the Projects table, and in the criteria of the Project Name field you can put the equivalent of this... ... If by "wildcard search" you mean you want to be able to enter just part of the Project Name in the textbox, then the criteria in the query would be like this... ...
    (microsoft.public.access.macros)
  • Re: SQL Query - precision error
    ... What I'm asking is, when you run the query and get the error, what value are ... >> Microsoft MVP ... >> ..Net Developer ... >> Sometimes the elephant eats you. ...
    (microsoft.public.frontpage.programming)
  • RE: Query by Form
    ... Now I cannot do a wildcard search with the ... I have played around with the query but I cannot figure it out. ... results of the query are displayed in a subform in the above mentioned form. ... By using the following criteria in each of the fields in my query (Like ...
    (microsoft.public.access.queries)
  • Re: why does this wmi query take 10 minutes on a dual proc 2GB memory raid 1 15K scsi server?
    ... what totally sped up the query. ... issues when doing a WMI wql query with a wildcard search because ... a long running query. ... filenaming practices like that. ...
    (microsoft.public.win32.programmer.wmi)
  • Re: Creating a drop-down list to select and run a query
    ... when I attempt a wildcard search the query brings back no results. ... >> form field. ... >> I click my search button the parameter dialog box in the querey opens asking ...
    (microsoft.public.access.queries)