Connecting Tech Pros Worldwide Forums | Help | Site Map

A simple query problem

Tero Partanen
Guest
 
Posts: n/a
#1: Nov 12 '05
Hi,

I have a small problem with MS ACCESS query.

I want to be able to have a field, where I can input the search
parameter, and then it will show me all the entires that match the
parameter. I have done this already (almost) using "Select Query",
where in the design view I enter the parameter in the "Criteria" field
of the query (under the field that I'm using for the query), but there
has to be a more simple way of doing it, ie. just a pop-up box or
something else where that search parameter (criteria) can be entered ?

regards,
Tero

Mark Reed
Guest
 
Posts: n/a
#2: Nov 12 '05

re: A simple query problem


What you need to use is a parameter query. You do this be entering [Whatever
text to display in popup] in the criteria section of the design window. When
you run the query, a message will pop up asking for the criteria to be
specified.

Mark

"Tero Partanen" <teropa@paju.oulu.fi> wrote in message
news:18984ff1.0405060208.6267b761@posting.google.c om...[color=blue]
> Hi,
>
> I have a small problem with MS ACCESS query.
>
> I want to be able to have a field, where I can input the search
> parameter, and then it will show me all the entires that match the
> parameter. I have done this already (almost) using "Select Query",
> where in the design view I enter the parameter in the "Criteria" field
> of the query (under the field that I'm using for the query), but there
> has to be a more simple way of doing it, ie. just a pop-up box or
> something else where that search parameter (criteria) can be entered ?
>
> regards,
> Tero[/color]


Closed Thread


Similar Microsoft Access / VBA bytes