How to allow users to query records in access runtime

[Alice]

I have created runtime version of my database.
In the runtime version, users cannot enter the
query criteria as they can do using the complete
version. How can I allow them to do so.
For the description field they would like
to enter something like '%land%' or '*pump%'

Thanks for your help!
-Alice

 

[Alice]

Cameron - thanks much. This really helps.
-Alice

-----Original Message-----
Making a query involves changing the design of the Access
file and runtime versions will not allow any design
changes. There is no way around that. Either they will
need full version or you will need to build some interface
in a form where they can add criteria then your form
builds the SQL statement based on their entries. If you
are not familiar with code in forms this can be daunting.
Its not as slick as code in a form but you can put
parameters on some ready made queries. make a query and in
the criterias or the fields you wish to check put a
question in square brackets. "ie. [What is the fisrt
name?]". When the query is run it will ask the user the
question and whatever they type in will be placed in the
criteria where the question was.
-Cameron Sutherland

-----Original Message-----
I have created runtime version of my database.
In the runtime version, users cannot enter the
query criteria as they can do using the complete
version. How can I allow them to do so.
For the description field they would like
to enter something like '%land%' or '*pump%'

Thanks for your help!
-Alice
.

.