searching

[Joachim Andersson]

im making an music database and would like to add some
kind of search function. my thought was that i could
search for artist name and/or song title. i live in sweden
so im not very familar with the english language. the fact
that im only 16 dosnt really help me either. id really
like some help with this problem.

 

[Les]

Hi,
Once you have created a table to store your
information, you can build a form (form wizard) to display
your information. Then, on the form, you can create combo
boxes based on artist name and song title. There is a
combo box wizard to help you do this. You can create drop
down lists that will display entire lists.
Hope this helps.

 

[Rolls]

If you are using the QBE window, you can create a query with a search
criteria. Below the field you're interested in on the Criteria line type
the following:

a) Like *Elvis*

or

b) [Enter artist name]

which will create a popup message box that will let you enter *Elvis* which
returns a query result consisting of any field that has the string Elvis
anywhere in it. Of course you can substitute any other name, Bjork or
whatever.

If you want to create a form with the form wizard you can add a combo box
that lets you select from a list of all artists listed in the table. Then
you can select from that list and have a query return all matchging records

If you're stuck, write back!.

 

[Guest]

im really kind of stuck... if you have time please write a
detailed instruction... and please keep it simple

 

[Jockos]

its something like this i want to do but i just don know
how! some kind of popup in which you can write the title or
artist and get the results in some form of table.