Dumb and Easy Question for You

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a simple form, or at least I think, that allows me to put in some of the letters of a series of parts and it will display the records associated with those that have the letters. For example, the user types DIL in the search text window, and the display shows all the parts that start with DIL, DIL3, DIL5 etc. and the rest of their record infomation.

I am thinking of using VB.Net but maybe this is an overkill, but I am more familer with VB 6. Any suggestions?
 
I would consider building a nice form, and then have a sub-form that will
display the "hit list" of your search.

Thus, in the after update event of your text box, you can go:

strSql = "select * from tblParts where Description like '" & me.textSearch &
"*'"

me.MySubForm.Form.RecordSource = strSql

I use the above code in the following screen shots:
http://www.attcanada.net/~kallal.msn/Search/index.html

And, for some ideas of other ways to "display" results of a search...you can
use grids...check out:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
 
Thanks, still feel pretty stupid, even though I have done some fairly complex programming in my earlier years. I kinda want this to look a little more user friendly and less Excelish, if you know what I mean, but maybe this will give me a starting point. I was reluctant to build with VB.
 
Albert -

From your second link shown below, for the grids, I'm curious about just what kind of company
"Prestigous Pimps" is....<g>


____________________________________


I would consider building a nice form, and then have a sub-form that will
display the "hit list" of your search.

Thus, in the after update event of your text box, you can go:

strSql = "select * from tblParts where Description like '" & me.textSearch &
"*'"

me.MySubForm.Form.RecordSource = strSql

I use the above code in the following screen shots:
http://www.attcanada.net/~kallal.msn/Search/index.html

And, for some ideas of other ways to "display" results of a search...you can
use grids...check out:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
 
Back
Top