Search Engine

[kacocal]

Hi all,



I am wondering whether someone can help me with this.

I am designing a search form. When I enter the keyword (say: Peter), and click the "Search" button, This form will search through the whole database and find all the related Tables, Forms, Subforms, and all other objects which has this keyword "Peter" in these objects. It will also show the actual objects which contain this keyword "Peter".

Any suggestions or feedback is really appreciated.

Thank you.

[orange]

I have a demo data base that will look for values across all tables, but Forms, Reports etc are not handled.
Good luck

[kacocal]

I have a demo data base that will look for values across all tables, but Forms, Reports etc are not handled.
Good luck

Thank you Orange. I think I can do it for the values across all tables. Are there any ways for me to find the keyword in Forms, Reports etc... I really want to figure that out.

[Micron]

do you mean you want to find a word occurrence in any control (e.g. textbox) on any open form or report? Or do you mean contained in the control's properties, such as name? I think the former...
If so, you may have to use a recordset clone that is related to the open form/report and loop through every field, record by record, using the InStr function.

[kacocal]

Micron,

Thank you. Yes it is the former.

All the hints are already here and I am going to follow them and work on it over the weekend.

Thank you all. Have a nice weekend.