mopntu

can you give a text box the ability to search a database, and if so how

reboot

I tried to think of some witty reply to this, but failed. If I have to answer your question strickly, the only answer I can give you is No. A textbox cannot search a database. Now... you could write code to search a database for the value placed in a textbox. Is this really what you're asking?

mopntu

yes thats what i need. thank you

gallicus

Please supply more information like the data base you are trying to query. This question is very broad, it covers a lot of what many programmers spend their careers doing! There is a lot of coding to be done for solve your problem. Try to break the problem down and into smaller chunks as ask these more specific questions. It sounds like this is a new area for you. It may well be worth investing time and money in a book. There are plenty of books recommmended in this forum.

Good Luck

Rezner

if you had a textbox called "txtSearchLastName" then you could use the value in it to search the database with something like this (using ADO):This would populate the recordset with people from the table whose last name is exactly the value in the textbox.

chris00

I am trying to do the same thing. Search my Database and then place the results in an MSHFlexGrid named msh.
How would the best way to do this.

Thanks in advance


Chris

Cogen

Maybe it's better to use sql for your purposes, but I thought I'd mention that if you already have recordsets in your application, you can also take a look at the methods Sort, Filter, and Search.

An example of the search would be ...

rsStudents.Find "Last_Name = '" & txtSearch.text & "'"

just an idea.

Cogen

sorry, I didn't mean Sort, Filter, and Search.

I meant Sort, Filter, and Find.

chris00

Cogen , Could you explain how I could list all record with "Pizza" (just an example) in the Description Colume, Which one of the thing you listed would I use. Then list it in the MSHFlexGrid (msh)

Sorry, I'm new to using a Database

Chris

Cogen

honestly, I'm not that familiar with the MSHFlexGrid, so I can't really help you there, but as far as returning all records with Pizza in the description column, you would use .Filter. The main thing to remember is that those methods do not take the place of your SQL query, but they can narrow an already existing query into your search information.
For example, you would still need a recordset that is fully populated (probably by sql).
Maybe using SELECT * FROM table_name. (that's pretty broad though).
Then, with the recordset that contains the returned data, you can narrow the recordset down by using the filter method.
rsRecordSet.Filter "Description = 'Pizza'"

Now you can use the rsRecordSet as you normally would, however only the records with Pizza in the Description will be available.

Then, when you are done displaying the information, you can reset the recordset back to it's original state by using ...
reRecordSet.Filter = adFilterNone

I hope that helps ...

matticus_99

Hi Chrisoo,
After you query the database you can use this line to populate the flex grid.

Set myGoodGrid.Recordset = myGoodRecordset

Edit:

Thats cool, I never took into account some peoples background may have been white.

dcl3500

Sorry Matticus_99 for editing that post, but pink was just too darn hard to see.

mopntu

i am trying to make a serchable japanese to english/ english to japanese dictionary with 2 textboxes (1 for search and 1 for translation) and a search button. i wanted the database to store information like this (nihongo - japanese)

chris00

I did what all of your posts said. But is there a way I can get partial maches such as "box" would find Lunchbox.


Chris

reboot

"Like %box"