nandostyle
asked on
How can I search certain info out of a datasource and fill other text box in the form with info of the same row where my search string is?
Bassically the customer will enter the part numbers and then click on "search..." to find the rest of the information from the database. Please See file attached.
I have implemented no code using a database yet. I do have a code to search into an excel list but it is very slow. I am not very good with databases but I have to realice that it migh be the only way to find the part info very fast.
Project-Print-Screen.JPG
I have implemented no code using a database yet. I do have a code to search into an excel list but it is very slow. I am not very good with databases but I have to realice that it migh be the only way to find the part info very fast.
Project-Print-Screen.JPG
ASKER
There are 19000 items in the spredsheet, definetly not a good way to go.
basically I know how to bind the text boxes to the database, but again I just need the user to enter the part numbers into the partnumber text boxes and the be able to seach the database and indext the text box to the record index where the search string was found.
What will be the "Select" string and how do I pinpoint the inded contol to the found index?
basically I know how to bind the text boxes to the database, but again I just need the user to enter the part numbers into the partnumber text boxes and the be able to seach the database and indext the text box to the record index where the search string was found.
What will be the "Select" string and how do I pinpoint the inded contol to the found index?
ASKER
I have been looking for this type of info, watching videos and stuff but still confused.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
While this place is great for getting specific questions answered, it's not the best place for getting 'lessons'. You probably should find a tutorial on the subject (google searches will reveal plenty of them) and then come ask questions on any specific issues you are having.