creating a search engine

[AppleEater]

My prime objective is to create a simple but practical search engine for a DB. The search will be done in a text field. The user must be able to search 1 or many key words and have a list of results to choose in (much like a web search engine).

Does someone have a idea how to do this ? thanks.

 

[Fuga]

I think you need to be more specific.

I have a pobability calculating form which might be called a search form. The user enters a value, and the db calculates probability for higher or lower values. For this I use a field, the value of which is inserted in a variable. The variable is then used in the where clause of queries.

In your case, the field could be a combo box, and the calculations are executed on the after update event.

But then again, I don´t know what you want really.

Fuga.

 

[afloyd]

I've put a couple of these things together and they can really be a challenge (as I'm sure your finding out). Fuga is right in that you will need to create a qurey or SQL string that uses an unbound text box as the criteria in the WHERE clause.

You can either build a query or code a recordset in VBA. If you want hyperlinks returned (like a web search) you field will have to be in hyperlink format. This also means that you have to give an address to each of the hyperlinks that the user can select.

Flowcharting your process can be very useful in this situation and then writing psuedo code to get your search loops roughed out.

-HTH