How can i do this?

[de049]

Hi all,

I have a DB in Access with numerous forms & tables.

I now need a launchpad (startup) menu where i would have buttons to open each form, and a DB wide search facilirty. This is where im stuck, with the search facility.

I need to get a text box where a user types the search criteria and then presses a button to perform the search. The result of the search would appear on a separate msgbox of somesort, where each result can be pressed and the corresponding form will be opened.

Perhaps someone can advise on different way of handling the results, but what i need is for the search to enable to user to search for particular data, as opposed to having to open various forms and locating the data manually.

please help

PS. Perhaps someone has a sample search similar to this one, which i can guide myself with. Im real stuck, coz its been a while since i programmed on Access and have become VERY rusty

 

[ColinEssex]

There are excellent examples in the sample database forum. The Quicksearch by Parker is the one I use as it updates a listbox with results as the user enters a string.

Col

 

[cable]

This will not be easy, as there is not a simple search all function.

So you'd have to build up the results of many searches, ie you search one table, save the results, search the next etc.

however these might be useful:
http://www.mvps.org/access/modules/mdl0056.htm
http://www.mvps.org/access/forms/frm0045.htm

The second does do what you want...but its not the most freindly UI.

 

[ColinEssex]

Can I just add that the database I referred to will search several fields in one table simultaniously but not several tables.

Col