| | |
Search form for imported database in visual basic.
![]() |
•
•
Join Date: Dec 2007
Posts: 1
Reputation:
Solved Threads: 0
Hello,
I'm having a bit of a problem building a search form in my visual basic database.
I tried (LIKE @Column + '%') or ('*'). No use because its not showing me the text box in wich i can actually search.
I think i'm having this problem because i've imported the database from Access and the columns are not declared in Visual Basic.
Can i build a diffrent search form? ( Text box + button or smthg... )
I appreciate any kind of help!
Thank You,
Andres Bogdan.
I'm having a bit of a problem building a search form in my visual basic database.
I tried (LIKE @Column + '%') or ('*'). No use because its not showing me the text box in wich i can actually search.
I think i'm having this problem because i've imported the database from Access and the columns are not declared in Visual Basic.
Can i build a diffrent search form? ( Text box + button or smthg... )
I appreciate any kind of help!
Thank You,
Andres Bogdan.
Ok, first off, is the database connection working? What technology are you using for database connectivity? DAO or ADO?
You build your query by including a text box value in the query string and then send the query via recordset or command object to the database.
So if you have a text box called txtSearch,
Pass that to your database to receive the information back...
You build your query by including a text box value in the query string and then send the query via recordset or command object to the database.
So if you have a text box called txtSearch,
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
dim qry as string qry = "Select * from sometable WHERE somecolumn LIKE '%" & txtSearch & "%' ORDER BY somecolumn ASC;"
Pass that to your database to receive the information back...
------------------------------------------------------------
If you see no coffee in my immediate vicinity, speak slowly and use small words....
ConnectNL Directory | Blog
If you see no coffee in my immediate vicinity, speak slowly and use small words....
ConnectNL Directory | Blog
![]() |
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Want to know about Golden Parser
- Next Thread: Where can I get E-Book for Visual Basic
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





