Query Criteria

[Guest]

I have a database of valves. I want the user to be able to search by EITHER
the equipment number or the description or the model number. I would also
prefer the user to be able to put in partial cell contects to search for.
(example PI303 instead of PI303-02-PT23).

Any help will be greatly appreciated.

David

 

[JK]

Create a combo box and make sue that the "Auto Complete" on (it is the
default)

Regards/JK

 

[Guest]

I am definately a novice. Can you go into a little more detail on the combo
box thing, please. Does this go on the query? I've put them on an excel
spreadsheet before but thats about it.

 

[JK]

David,

Where do I start?
Can you please tell me what have already? Tables, queries, forms?

Regards/JK

 

[Guest]

I have a table with the data in it. I have a query that I can manipulate
manually using =[] to get what I want but I dont want anyone else to have to
manually change the query like that.

I have written tables, queries, forms and reports in a different application
but not with the search function like I am looking for in this one.

Thanks

 

[JK]

Create a continues form, if you don't know how use the wizard to do it for
you,

In the forms section select "New", a dialog box will open. At bottom select
the query as the source for your form, in and select "Auto Tabular" and let
access do it for you. Save it and go to design view,

Enlarge the header to allow you to put a combo box (drag the header border
down).

Click the Tool Box icon (hammer & Spanner) to select the combo Box (run the
cursor on individual icons inside the box until to locate the combo box
tool. Click on it and go to the form header and draw a quare which is
boundary of the combo.

A wizard will open - accept the default and click next and follow
instruction (accepts defaults to start with.)
I suggest that you "play" with it for a while until you are more familiar
with the combo box

when you get the feel for it post a question again - it will be easier to
explain further.


Regards/JK

I have a table with the data in it. I have a query that I can manipulate
manually using =[] to get what I want but I dont want anyone else to have
to
manually change the query like that.

I have written tables, queries, forms and reports in a different
application
but not with the search function like I am looking for in this one.

Thanks

David,

Where do I start?
Can you please tell me what have already? Tables, queries, forms?

Regards/JK